Sum the value of unbound control in report

[beemomo]

I need a report that generate the total value of project from a few foreign currency to USD.

In report detail section:
There are 2 fields (CURRENCY,CurrV alue) from query table which are displayed in bound control (text box)

To convert to value in USD, I have created a text box txtConRate, where users need to key in the conversion rate. Then there is another text box (txtValueinUSD) to calculate the converted value, where i set its control source to =[CurrValue]*[txtConRate]

In report footer:
I try to get the total converted USD amount and set the control source of txtTotalUSD as Sum([CurrValue]*[txtConRate]), but it wouldn't work. Sum only work for the fields from query/table, but it did not work for unbound value/calculated value :(
Can anyone guide me how can i get the total value for converted USD? Thank you very much.

[NeoPa]

You talk about an operator entering an exchange rate into a TextBox in your report. That's not possible is it? TextBoxes in reports are not updatable by the operator.

[beemomo]

Thanks NeoPa for your reply.
Hmm, no other way except enter the exchange rate into another table and query to get the result?

Beemomo

[NeoPa]

I don't follow clearly what you're asking (or your response to my question) so I'll try again, with a slightly updated understanding.

Maybe you are thinking about this rather than already have it working. If so, have you considered controlling the input from the operator via a form?

[beemomo]

yes, i've considered that before, input the value via a form. But the purpose i let user to enter the value of the exchange rate in the report is because, they only have to enter the rate for the particular currency group after the report is being generated.

[NeoPa]

As I have very little idea of what is in your report I have equally little idea what your explanation means. I can only understand things I have experience of. I have no experience of anyone being able to enter values into a report. I have no idea what is in your report. Anything you say which requires such knowledge is meaningless until I have the knowledge to work with.

Let's start again, as you seem to be coming round again to talking of entering values into reports. Are you possibly talking about a parameter of the query the report is built on?