Can't Calculate Fields on a report

[StaceyJ]

Okay, here is my situation.

I have several customer records within one table. I used a query to filter
records from that table, and am now using the query to create a report.

Here is what I’m trying to do.

For instance the report is setup to list customer name, customer company,
renewal date, renewal period, and I want to create a field that lists total
price (Renewal Price). The recurring amount field must be calculated based
on several other fields. Those fields are, for instance: Package Price.
Setup Price Option Price.

Records are grouped by renewal date, and then all the other info is listed
under that.

So here is how the report looks currently.


RENEWAL PERIOD: Annual
COMPANY CUSTOMER NAME RENEWAL DATE RENEWAL PRICE (field name:
total_price)
Microsoft Bill Gates 07/08
TO BE CALCULATED


Do I need to hide the Package Price, Setup Price, and Option Price fields in
the detail section of that row so my total_price field can be calculated?
Because that doesn’t seem to work either. Rather, every time I open the
report, it gives me that dialog box that lists the name of a fields, with a
blank spot to enter a value. I don’t know why. Shouldn’t it be pulling
those values from the actual customer information?

What should the formula for my calculation field be?

 

[Adam Milligan]

Stacy-

In the query that you created to be the recordsource of your report, add a
calculated field by putting curTotalCost:[Package Price]+[Setup
Price]+[Option Price] where it asks for the field. The field 'curTotalCost'
should then show up in your field list for that report (you may have to close
the report and open it again before it will show up). Hope that helps.

Adam