Calculating totals from filtered datasheets

[Tommo]

Hi



I am banging my head against the wall here.

I am building a DB for a dance school.

I have data sheets as subforms on a Main nav page that show the students and the classes they are enrolled in.

I have combo boxes to filter this for individual classes/students.

I think this makes sense so far.

On the Classes By Student DS I have the cost of each class. I want to total these classes per student and start building an accounts system that will show how much they owe and how much they have paid. I just need to start with the totals though. How would I do this??

On the Student by Classes DS I want to generate registers as reports. The only hard this in this is I would like to have a box for each class date on the form. I have put the term dates in a small table and I want a box for each class day from that.

No idea really.

Please Help.

Please

[ranman256]

showing your classes and student tables, charges are made to the Charge table using a students ID
payments are made that way also. Eventually sum of payments must equal sum of charges.
FORM: classes is the masterform, and Student are the subform, to add students to the class.

tClasses
----------
ClassID (auto)
ClassName ballet 101,tango, charleston
StartDate
Instructor

tStudents
-------------
StudentID (auto)
FirstName
LastName
Address....

tCharges
-------------
chargeID (auto)
ClassID (long)
StudentID (long)
ChargeDate
ChargeAmt

tPayments
---------------
PayID (auto)
StudentID (long)
AmtPaid
DatePaid
PayType (check,cash,MO,visa)
ClassID (long)

as for PART2 of your question, FORM2 (by reversing the 1st form ) where Student is the masterform, and classes are the subform,
you see all classes by 1 student.
you will also want subforms for PAYMENTS, & CHARGES.
and maybe a hybrid, that combines payments & charges to see the balances of each.

[Tommo]

Thanks for quick reply!

How do I generate totals per student and per class??

[June7]

Maybe build report(s)? Use report Sorting & Grouping features with aggregate calcs in group and report header/footer.