Sum the value of unbound control in report footer

[beemomo]

This is my second post for the same question, hope this time I did explain more clearly about my problem.

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

In report detail section:

-2 textboxes bound to CURRENCY and CValue from a query.
-Another 2 textboxes (unbound control) -> txtRate and txtUSD

CURRENCY CValue Rate Value(USD)
txtCurr txtCValue txtRate txtUSD

-users need to key in the conversion rate in txtRate.
-txtUSD used to calculate the converted value, where i set its control source to =[CValue]*[txtRate]

In report footer:
-another textbox txtTotalUSD is created, its control source set to Sum([CValue]*[txtRate]), but it wouldn't work and keep prompt me to enter value in txtRate.Sum only work for the fields from query/table, but it did not work for unbound value/calculated value.

Is there a way to get the total amount for USD from the unbound field in report detail? Please advise me on this, thank you very much.

Beemomo

[nico5038]

You can't type in fields in a report.
In this case I would create a conversion rate table and make sure that all used currency codes are present for the required report. When missing, jump to the currency code table instead of showing the report.

For the report you can join the tblCurrencyCodeRate to calculate the USD price.

One other consideration should be the use of a currency date, as they can differ over time....

Nic;o)

[beemomo]

@nico5038
Hi Nic;o),

Thank you so much for your advise. Yup, you are right, and also the unbound text box of txtRate is not working properly in report as in it works in form. Store the currency value in another table will be the solution.

Regards,
Beemomo

[nico5038]

Glad I could help and success with your aplication !

Nic;o)

[Khuram]

ur data comes from query. u can make calculation field in query and then make bound control to that calculated field in ur report. then u can take sum