Amount claimed Sub total

  • Thread starter Thread starter Mavis
  • Start date Start date
M

Mavis

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.
 
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....
Click to expand...
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 said:
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.
Click to expand...
 
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....
Click to expand...
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 said:
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.
Click to expand...
 
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very sure
how to do the stp you mention below. Can you advice me?

Thanks!

Al Campagna said:
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....
Click to expand...
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 said:
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.
Click to expand...
Click to expand...
 
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very sure
how to do the stp you mention below. Can you advice me?

Thanks!

Al Campagna said:
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....
Click to expand...
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 said:
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.
Click to expand...
Click to expand...
 
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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 said:
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

Al Campagna said:
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....
Click to expand...
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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 said:
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

Al Campagna said:
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....
Click to expand...
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Hi,

In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is error.
For your infor, USDConversion is not store in the table.

Thanks!


Al Campagna said:
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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 said:
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

Al Campagna said:
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."

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.
Click to expand...
Click to expand...
Click to expand...
 
Hi,

In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is error.
For your infor, USDConversion is not store in the table.

Thanks!


Al Campagna said:
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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 said:
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

Al Campagna said:
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."

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.
Click to expand...
Click to expand...
Click to expand...
 
Mavis,
In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
Click to expand...
Click to expand...
If there is an error... tell us what the error is... in as much detail
as possible.

If your referring to the calculated field in the query, it should be...
USDConversion : [ClaimedAmount]*[ROE]
Notice the ":" that separates the name of the calculated field from the
calculation.
--
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 said:
Hi,

In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
For your infor, USDConversion is not store in the table.

Thanks!


Al Campagna said:
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates
the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource
of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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 said:
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

:

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."

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.
Click to expand...
Click to expand...
Click to expand...
 
Mavis,
In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
Click to expand...
Click to expand...
If there is an error... tell us what the error is... in as much detail
as possible.

If your referring to the calculated field in the query, it should be...
USDConversion : [ClaimedAmount]*[ROE]
Notice the ":" that separates the name of the calculated field from the
calculation.
--
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 said:
Hi,

In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
For your infor, USDConversion is not store in the table.

Thanks!


Al Campagna said:
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates
the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource
of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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 said:
Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

:

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."

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.
Click to expand...
Click to expand...
Click to expand...
 
Hi,

Thanks, i got it!



Al Campagna said:
Mavis,
In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
Click to expand...
Click to expand...
If there is an error... tell us what the error is... in as much detail
as possible.

If your referring to the calculated field in the query, it should be...
USDConversion : [ClaimedAmount]*[ROE]
Notice the ":" that separates the name of the calculated field from the
calculation.
--
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 said:
Hi,

In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
For your infor, USDConversion is not store in the table.

Thanks!


Al Campagna said:
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates
the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource
of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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."

Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

:

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."

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.
Click to expand...
Click to expand...
Click to expand...
 
Hi,

Thanks, i got it!



Al Campagna said:
Mavis,
In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
Click to expand...
Click to expand...
If there is an error... tell us what the error is... in as much detail
as possible.

If your referring to the calculated field in the query, it should be...
USDConversion : [ClaimedAmount]*[ROE]
Notice the ":" that separates the name of the calculated field from the
calculation.
--
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 said:
Hi,

In the field i out [USDConversion]=[ClaimedAmount]*[ROE] but there is
error.
For your infor, USDConversion is not store in the table.

Thanks!


Al Campagna said:
Mavis,
There is only so much we can do via email. I'll lay out the
basics again, and hope that that will help.
I would suggest a Beginner's Access class if one is available.
Or... perhaps an Access How To reference book to supplement
Access Help... if you don't have one already.

First, let's handle the query behind the report.
Using the Query design grid... bring the table/s you want to base the
report on into the query, and drag the fields you want on the report onto
the design grid. (including ClaimedAmount and ExchangeRate)
In a blank column of the grid, create a calculated field...
On the "Field:" line put
USDAmount : [ClaimedAmount]*[ExchangeRate]
This creates a "bound" field named [USDAmount]... which calculates
the
value, and that field can be placed on the report, just like any
normal table field.

With this field on the report, use the report design's
Grouping and Sorting dialog box to create a Group Footer on your
Category field.
In the Category Group Footer, a text control with a ControlSource
of...
= Sum(USDAmount)
will give the total of the USDAmounts for each different Category.

In the Report Footer, a text control with a Control Source of...
=Sum(USDAmount)
will yield the sum total of USDAmount... for 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."

Hi,

Thanks so much for your prompt reply. I am very new to access. Not very
sure
how to do the stp you mention below. Can you advice me?

Thanks!

:

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."

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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top