Re: Amount claimed Sub total

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

Mavis,
Several ways to do that...
One method is to create a calculated field in the query behind the
report.
USDAmount : [ClaimedAmount] * [ExchangeRate]
Place the bound USDAmount on the report.
After every catagory of each item i will need....
Using your Grouping and Sorting to create a "Category" Group Footer.
In that Category Group footer, a calculated field named CategoryTotal
with a
ControlSource of...
= Sum(USDAmount)
will yield the totals for each category.
In the ReportFooter...
= Sum(USDAmount)
will yield the USDAmount total over all Categories.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Mavis" <Mavis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F81FCB9C-D07D-440C-A44F-CBE5AA4107C1@xxxxxxxxxxxxxxxx
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

  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: Nz in report section heading
    ... even better on my existing query because I already ... another calculated field into the query which feels a little better. ... In your query behind the report, ... control's control source is a field in that query. ...
    (microsoft.public.access.reports)
  • Re: Error Message when running report
    ... You either have a bad reference in your code, a calculated field in the report, or the query that the report is based on. ... Whenever you change code or references, your should always compile before executing. ...
    (microsoft.public.access.reports)
  • Re: Amount claimed Sub total
    ... If your referring to the calculated field in the query, ... let's handle the query behind the report. ... will yield the totals for each category. ...
    (microsoft.public.access.reports)
  • Re: Amount claimed Sub total
    ... If your referring to the calculated field in the query, ... let's handle the query behind the report. ... will yield the totals for each category. ...
    (microsoft.public.access.reports)