Changing currency format on the fly

[deejay_totoro]

Hello,

I would like to format the currency values in a query. There values will either be Euro or Pound. Is it possible to change the currency format "on the fly" in this way in a query?

I would like to have a variable currency format. For example:

If [fldCurrency] = [Euro] Then format [fldAmount] As Euro
If [fldCurrency] = [Pound] or [GBP] Then format [fldAmount] As Sterling

How does one format data as Euro?

Many thanks,

Dj_T

 

[Matt Greatorex]

NumberField = Format(NumberField,"#,##0.00 [$€-1]")