Calculations within report

[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

 

[[MVP] S.Clark]

You could sum the total spent in another query, such that it's available for
the report. DSum might help too.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[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

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

[quoted text clipped - 19 lines]

Steve