Calculating in a report

[snirp]

I've been trying to create a report with a grouping followed by a calculated field and I keep getting an error message "Data Type Mismatch in criteria expression." What I'm trying to do is create a field that will calculate the totals for each group. All of the fields are in the currency format but I still get that error message. Does anyone know what I'm doing wrong?

Sorry if I haven't given enough information.

Thanks!

 

[GumbyD]

I am guessing that your property looks something like:

=sum([CurrencyField])

Where the CurrencyField is in the detail or some grouping header or footer. Make sure that you are not trying to sum in the page footer as that will cause an error. You may also want to make sure that you have not inadvertantly formatted you currency field in the field propeties on the report. If you use the CCUR function in the query that will make sure it is a currency value in the query and will be formatted for you when it gets to the report.

Good Luck.

GumbyD