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" <(E-Mail Removed)> wrote in message
news:9BB8F9F1-BB12-413D-B159-(E-Mail Removed)...
> 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