I am creating a Microsoft Access database for my office and am trying to create a Report to show every purchase for the whole office. My office is split into 4 teams, and, due to the differing purchases per team, 4 tables were created for each team with fields pertaining to their purchases. There are a few fields however that span across all teams, such as: Purchase Number, Purchaser, etc..
My question is how do I create one report with a list of all the purchases in the office that will combine these fields from the separate tables into one field? None of the info in these fields will be duplicated across, I just need the field on the report to contain information from all 4 tables.