I have three tables with data.
Table1 is data for meals.
Table2 is data for room costs.
Table3 is data for payments made.
Each of these tables has a foreign key for EventID.
I'm trying to produce a report that will show, for each EventID:
The total billed (which is meals + rooms)
The total paid (from Table3)
The balance due (the difference from the two above).
Is there a straightforward way to do this? Do I have to create summary queries for each table?
Thank you!
Table1 is data for meals.
Table2 is data for room costs.
Table3 is data for payments made.
Each of these tables has a foreign key for EventID.
I'm trying to produce a report that will show, for each EventID:
The total billed (which is meals + rooms)
The total paid (from Table3)
The balance due (the difference from the two above).
Is there a straightforward way to do this? Do I have to create summary queries for each table?
Thank you!
