calculation problems....

[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

 

[Marshall Barton]

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?

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)