View Single Post
  #1  
Old March 30th, 2010, 06:02 AM posted to microsoft.public.access.forms
George
external usenet poster
 
Posts: 883
Default Change Currency Using a Form

Hi,

Not sure if a Form is the right way to go but i what i need is to apply a
USD/Australian Dollar (AUD) currency value on a certain date to a query or
report so that the market values in the report is either AUD or USD depending
on what i want.
Kind of long winded but my data will initially be in AUD and i want to ask
the user if they would like to convert the currency to USD and if so a table
is sourced and the USD conversion rate is applied to the market values.
any help here would be great.
thanks
George