I have a large Excel spreadsheet with five "worksheets". Four are purely tables (all unrelated, maybe with the exception of event dates). The last worksheet is used to sum certain columns within each of the tables, and then make two calculations based on those sums.
I've successfully imported the four tables into Access and created a form for easier data entry.
However, I'm stuck trying to create the "Report". I'm using queries to calculate the needed sums, but I cannot figure out how to make final calculations in a Report from the queries. The Reports I've tried only let me display queries created from a single table at a time, which isn't helpful.
I've successfully imported the four tables into Access and created a form for easier data entry.
However, I'm stuck trying to create the "Report". I'm using queries to calculate the needed sums, but I cannot figure out how to make final calculations in a Report from the queries. The Reports I've tried only let me display queries created from a single table at a time, which isn't helpful.