calculation problems....

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

fiona.innes

hey...

I have a report which displays values in dollars (txtVale) and also an
exchange rate (txtRate) I have added another text box called
txtSterling which calculates the dollar value to pounds ie =([txtVale]/
[txtRate]). I have my report grouped as entries are either arrivals or
depatures, in the footer for the grouping i want to sum up the
converted values and i have in the caluclaution =sum([txtSterling]).
Only problem is when i run the report the calculation
=sum([txtSterling]). gives the wrong answer. Does anyone know why?

Fiona
 
I have a report which displays values in dollars (txtVale) and also an
exchange rate (txtRate) I have added another text box called
txtSterling which calculates the dollar value to pounds ie =([txtVale]/
[txtRate]). I have my report grouped as entries are either arrivals or
depatures, in the footer for the grouping i want to sum up the
converted values and i have in the caluclaution =sum([txtSterling]).
Only problem is when i run the report the calculation
=sum([txtSterling]). gives the wrong answer. Does anyone know why?
Click to expand...


The aggregate functions (Count, Sum, Min, etc) are query
functions. They can only operate on *fields* (columns) in
the report/form record source table/query. They are unaware
of *controls* (text box, etc) on the report/form.

To do what you want, sum an expression like:
=Sum(Vale / Rate)
 
Back
Top