Calculations within report

  • Thread starter Steve R. via AccessMonster.com
  • Start date
S

Steve R. via AccessMonster.com

I have a report that shows line item spending against a master PO - it sums
the individual line item spending by vendor, shows the total amount to be
spent, everything is fine.

But I want to show the difference between TOTAL SPENT and TOTAL BUDGETED - I
can't just name the text boxes like "TotalSpent" and "Totalbudgeted" and
create an unbound text box that says:

=SUM([totalSpent]-[totalbudgeted])

.... because the calculations are based on the reports objects - I think it
will work if I incorporate :

Me!

or

Me.

.... but I'm not certain of the exact syntax for my text box

Steve
 
S

Steve R. via AccessMonster.com

S. Clark,

Thanks - actually I did a search on this site and found a post that helped
answer my question - so kudos to "Access Monster"

Thanks for the input,
Steve


[MVP] S.Clark said:
You could sum the total spent in another query, such that it's available for
the report. DSum might help too.
I have a report that shows line item spending against a master PO - it sums
the individual line item spending by vendor, shows the total amount to be
Click to expand...
[quoted text clipped - 19 lines]
Steve
Click to expand...
Click to expand...
 
Top