I am in the process of setting up a DB for field testing of water samples. We have 65 customers with multiple sample location at each site (1 to 7) and multiple tests per sample location (1 to 25) which vary per each quarterly period. In Excel, I have created a spreadsheet showing the required sampling by each customer, sample location, test and quarterly period. (All in one Table with the various locations (under one Location_ID field) and sampling tests by quarter as their own fields).
However, once I created the same table in Access, I am having difficulty in organizing a single page form which is to show each customer with all locations and corresponding tests. (Physically it can be done on a standard size page).
The issue that I am having is that instead of a single page form for each customer, I am getting multiple pages which correspond to the actual number of locations per each customer.
I can accomplish what I need by exporting the DB Table into Excel and then using the transpose function. However, now in Excel, the Customer names appear in multiples reflecting the number of locations.
How can I aggregate each customer with the various test locations and the corresponding test variables on a single page in Access?