J
Jennifer Cali
Hello,
I have four tables: tblEvent, tblLighting, tblAV, and tblScenic. Each table
has a corresponding form frmEvent, subformLighting, subformAV, and
subformScenic (the sub's are all subforms in the main frmEvent).
The three subforms are set up as datasheets with a SUM function in the
footer of each form...the forms track the total cost of AV equipment,
Lighting costs, and scenery costs for setting up local plays. I want to have
a display tab that shows the total project costs by category but don't know
how to accomplish this. Would it be through a query which would become a
subform shown as display only values?
Please let me know if this doesn't make sense and I'll try to explain
better. Thanks!
I have four tables: tblEvent, tblLighting, tblAV, and tblScenic. Each table
has a corresponding form frmEvent, subformLighting, subformAV, and
subformScenic (the sub's are all subforms in the main frmEvent).
The three subforms are set up as datasheets with a SUM function in the
footer of each form...the forms track the total cost of AV equipment,
Lighting costs, and scenery costs for setting up local plays. I want to have
a display tab that shows the total project costs by category but don't know
how to accomplish this. Would it be through a query which would become a
subform shown as display only values?
Please let me know if this doesn't make sense and I'll try to explain
better. Thanks!