Calculating "remaining budget $'s by project"

[madcreek]

I need to build a report that will show the remaining $'s by project. I will need to take a specific "project budget amount" and subtract the "paid invoices" leaving a "remaining budget amount". I have the "project budget amount" in the ProjectTable, and the multiple "invoices amounts" in the InvoiceTable. So how do I report the one budget amount, the multiple invoice amounts, (subtract the two), and then show a remaining balance?

[pbaldy]

I would create a totals query that sums up the invoice amounts by project. Then in a second query you can join the project table to this query and easily do the math to get the difference.

[madcreek]

Thank you, I will try this.

[pbaldy]

No problemo, post back if you get stuck. Welcome to the site by the way!