Can this be done in Access?

[Gerbil333]

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.

 

[VinylxScratches]

You need to develop relationships if you want to query across different tables.

 

[Gerbil333]

What if they don't relate?

 

[C1]

Actually I used to do quite a bit of ACCESS some time back. Of course what you want can be done with Visual Basic, but I realize that it isnt worth learning VBS just for one report.

Can you build a separate table containing the query results, then just have the report printout based on the one table containing the calculated results?

 

[Gerbil333]

Originally posted by: C1
Actually I used to do quite a bit of ACCESS some time back. Of course what you want can be done with Visual Basic, but I realize that it isnt worth learning VBS just for one report.

Can you build a separate table containing the query results, then just have the report printout based on the one table containing the calculated results?

Thanks, that was a helpful hint. I ended up creating a query from scratch, which contains results from all of the original queries. Essentially, it's a table of the results. Creating the desired report was then no problem.