Calculations in a Report

  • Thread starter Thread starter fiona.innes
  • Start date Start date
F

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
 
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?
 
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..
 
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...".
 
Back
Top