currency symbol in reports

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Mark Andrews" <mandrews__NOSPAM__@xxxxxxxxxxxx>
Date: Thu, 26 Oct 2006 09:59:25 -0400

I would like to make the currency symbol on all numeric fields in a report
to show the appropriate currency
based on user selection. In this example the amounts are all expressed as
the currency picked by the user on an ASP web page.

However the query which drives the report has the currency code (USD, GBP,
CAD, EUR etc...)

Advise on how to accomplish this?

Thanks in advance,
Mark

.

Follow-Ups:
- Re: currency symbol in reports
  - From: Brendan Reynolds

Prev by Date: Re: pull one of each group per page?
Next by Date: Re: Print the record only if there is data in a field
Previous by thread: Re: access reports design view when trying to print
Next by thread: Re: currency symbol in reports
Index(es):
- Date
- Thread

Relevant Pages

Dollar declines on plans to ditch dollar-oil price
... LONDON -- The dollar fell on Tuesday, hit by a media report that Gulf ... The report was denied by Kuwait, but the European single currency rose ... The Australian dollar jumped after the Reserve Bank of Australia ...
(talk.politics.misc)
Dollar declines on plans to ditch dollar-oil price
... LONDON -- The dollar fell on Tuesday, hit by a media report that Gulf ... The report was denied by Kuwait, but the European single currency rose ... The Australian dollar jumped after the Reserve Bank of Australia ...
(sci.military.naval)
Dollar declines on plans to ditch dollar-oil price
... LONDON -- The dollar fell on Tuesday, hit by a media report that Gulf ... The report was denied by Kuwait, but the European single currency rose ... The Australian dollar jumped after the Reserve Bank of Australia ...
(soc.culture.pakistan.politics)
Re: Invoice Calculations, FindRecord Command, please help!
... > Private Sub Calculator_Click ... > Dim CalcSigning As Currency ... The report is then sent to an e-mail ...
(microsoft.public.access.formscoding)
Re: Database design issue
... is generating the report wants to see the amount in his own currency. ... So at the time of report generation, for each row, it has to calculate the FX rates for that amount. ... I wouldn't expect more than say a couple of hundred entries in the Currency conversion table which you could read into a memory cache at the start of your report - unlikely to take you more than say 10 to 20 msecs with any decent database - and performing the conversion using an in-memory table will probably cost you very very little in terms of time. ...
(comp.lang.java.databases)