How can I create formulas in an access report?

[Guest]

I am trying to create a report in Access, where I will be pulling totals
from a variety of different tables, but then in one report, I want to reflect
those totals and then add formulas. For example:

2006 Sales $2,000,000
2006 Duplicate -1,000,000 (this would be a number I would have to put in
the report and I'd like for it to prompt me for it)
Total $1,000,000 (this is where I would put a formula
subtracting $1,000,000 from the $2,000,000

Thanks!

 

[Jeff L]

You would have a text box for Sales, Duplicate, and Total on your
report. The sales text box would have the sales field from your data
source in it. The Duplicate text box would have =[Duplicate Amount] in
it. Finally, the Total text box would have =[Sales] + [Duplicate]
(assuming that you are putting in a negative number as in your example)

Now when you run the report, you will be asked for Duplicate Amount and
your calculations should work.

Hope that helps!