Amount claimed Sub total

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi All,

I have this report which is setup using a query.
The following will be my fields of the report.

Exchangerate, Currency, ClaimedAmount, USDAmount.

The vaule of USDAmount is genarated using a forumla,
"=[ClaimedAmount]*[ExchangeRate]".

After every catagory of each item i will need to have a sub USD total.
There will be a Overall USD total in the report.

Can anyone advice how can i get the sub USD total and Overall USd total?

Note: Each line can be in different currency.

.

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)