* Total Field *

[QuinnMallory]

nGreetings.

I have two (2) tables: 1)Total Dollar Amounts per Cost Center for the Year
and 2) detailed invoice spending, broken down by cost center.

How do I generate a report with a created field Total Left to spend based on
the the single amount in one table (1) and the SUM of the total spend in
table 2? (Total for the year - Total spend Year-to-date?)

Thanks.

 

[Jeff Boyce]

If you are storing [Total Spent Year-to-Date] in a field, you're treating
Access as if it were a spreadsheet.

If you actually have individual detail records, use a query to sum them.

Then create another query that joins the total amt per Cost Center to the
Sum of amounts in the second table. In this new query, calculate the
difference.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

P.S.

You can use a query (the second one) as the source for either a form or a
report...

Regards

Jeff Boyce
Microsoft Office/Access MVP