Change currency values in report.

[George]

Is it possible to change values in a report from Australian dollar to USD?

The report is currently set up in Australian dollars and i would like to
maybe use a form to have the USD currency value change the values in the
report to USD.

Is there a simple way to do this?

Thanks
George

 

[Allen Browne]

You will need some way to specify the current exchange rate.

Say you open a form (Form1) with a text box (txtExchangeRate) that has the
current exchange rate. You can then place a text box on your report (or in
its source query) to convert the value, e.g.:
=[Amount] * [Forms].[Form1].[txtExchangeRate]