Change currency values in report.

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

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]

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"George" wrote in message
...
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