Calculations in a Report

[fiona.innes]

Hiya,

I have designed a customes database which has 2 tables tblCustomEntry
& tblRate.
Every month there are new exchange rates entered into the tblRate,
when entering data into tblCustomEntry
the user can select the currancy, rate & month which the entry is
related to from a drop down list.

I have a query which pulls all the values together i.e monthly rates
and the customes entry (qryReport) into a report called rptAudit.
Currancy values that are entered are dollars or Euros which i have set
up a grouping on the currancy field and have created a calculation
which works the currancy in pounds and is displayed in the field
(fldCurrancyValue) using the entered exchange rate. At the footer of
the report i want to sum up the calculated pound values that are
displated in the fieldCurrenacyValues, but it does not allow the
calcualtion, when you run the report is asked for a entry for the
field fldTotalCurrancy.

Does anyone know how i can over come this problem and be able to get a
grand total at the bottom of the report.

Fiona

 

[Duane Hookom]

Do you have a field in your report's record source named "fldTotalCurrancy"?
Are you sure this isn't just a spelling mistake since I would expect
fldTotalCurrency?

Did you place the text box in the Report Footer or the Page Footer?

 

[fiona.innes]

Sorry the field that displayes the converted currancy value is called
"fldCurrancyValue" and has the calculation =[cost]/[rate] - which
gives the converted rate in pounds and the text box in the report
footer is called "fldCurrancyTotal" i have =sum([fldCurrancyValue])
and it comes up with the parameter promt to enter fldCurrancyValue..

 

[Duane Hookom]

The value is displayed in a "text box", not a "field". You can't sum a text
box. You can sum the the control source from a text box.

Try set the control source of the text box in the report footer to:
=Sum([cost]/[rate])

It's a good idea to use a naming convention as you have. However "fld.."
might best be limited to actual fields in a table (not in my conventions). I
generally suggest naming text boxes like "txt...".