Amount claimed Sub total

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

Al Campagna

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

Al Campagna

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

Mavis

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

Mavis

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

Al Campagna

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

Al Campagna

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

Mavis

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

Mavis

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

Al Campagna

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

Al Campagna

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

Mavis

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

Mavis

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Toal Amount 4
How do I sum an IIF function in an Access Report? 20
Download data from web page 10
total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi 2
Summary of Unique item values 2
Converting amount($) of my expenditure into the base currency i wa 1
Remove certain group record from report 1
DLookup and Conversion in Report 1

Top