Prev: Some of my info added on forms fails to show up in the report.
Next: Page Count Error
From: George on 29 Mar 2010 00:25
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
From: Allen Browne on 29 Mar 2010 01:57
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" <George(a)discussions.microsoft.com> wrote in message
news:9BB8F9F1-BB12-413D-B159-A5F04F28FB79(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Some of my info added on forms fails to show up in the report.
Next: Page Count Error