Total Calculations

[thefriz]

Hello all! New to the forum and [fairly] new to Access.



I'm creating a database to keep track of attendees for an upcoming event I'm hosting. I have 4 tables: tbl_attendees, tbl_company, tbl_transactions, tbl_boothcost. The company table stores profile information about the company. Each company can have many attendees--each attendee can register at different costs (calculated field). The company must purchase a booth at different rates (tbl_boothcost). The tlb_transactions will keep track of each deposit made towards the company's amount due.

I've created a Company Form that displays the company information with a sub table that show attendees representing the company and their total dues. I need to create a field on the form to display the total amount due from the company--booth cost + sum of all attendee costs + misc field. I'm not sure if a query is the way to go? An expression? If so, where?

Then, once I start receiving checks, I need to keep track of deposits (tbl_transactions) and deduct that from the "total amount due".

I'm stumped. I've got all sorts of idea; however, just don't know how to do it.

Any help would be greatly appreciated!!!! Thanks in advance.

[ranman256]

queries are always the way to go. put your calculations in the query with a calculated field, in a blank column : [field1]*[field2]+1

myself, it would also have a TotalDue fld on the tCompany table. As rentals and payments come in, add or deduct from it. (queries)
This would reconcile with the transaction table.

[thefriz]

queries are always the way to go. put your calculations in the query with a calculated field, in a blank column : [field1]*[field2]+1

myself, it would also have a TotalDue fld on the tCompany table. As rentals and payments come in, add or deduct from it. (queries)
This would reconcile with the transaction table.

I figured it'd be a query--the methods that I've tried fail. How do I group the attendees then calculate? then add?

I'd assign the "totaldue fld" the value of the query correct?

THANKS!