adding up totals column in report

  • Thread starter Thread starter Haroon
  • Start date Start date
H

Haroon

hi

i have a report which displays a customers name chosen by user at prompt
when report is ran, the total cost column is there along with name, date,
ref, product type, etc
and i want to add the totals column in the report at the bottom,

its something like this...

date ref product_type customer_name
total_cost
1/1/09 bm001 abc b&b co
$10
2/1/09 ek032 abc2 b&b co
$20

i want report to display the grand total of the total_cost column

any ideas?
thanks in advance.
 
Haroon,
It appears (or you did not indicate) that you don't have any Grouping,
so we'll use the Report Footer to sum all the records.
I'll also assume that [Total_Cost] is a bound field, and not the result
of a calculation on the report.

Place a text control in the report footer with a Control Source of...
=Sum([Total_Cost])
---
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."
 
thanks alot,
i did manage to work it out as i placed the tex control box in the wrong
place on the page.

Al Campagna said:
Haroon,
It appears (or you did not indicate) that you don't have any Grouping,
so we'll use the Report Footer to sum all the records.
I'll also assume that [Total_Cost] is a bound field, and not the result
of a calculation on the report.

Place a text control in the report footer with a Control Source of...
=Sum([Total_Cost])
---
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."

Haroon said:
hi

i have a report which displays a customers name chosen by user at prompt
when report is ran, the total cost column is there along with name, date,
ref, product type, etc
and i want to add the totals column in the report at the bottom,

its something like this...

date ref product_type customer_name
total_cost
1/1/09 bm001 abc b&b co
$10
2/1/09 ek032 abc2 b&b co
$20

i want report to display the grand total of the total_cost column

any ideas?
thanks in advance.
Click to expand...
Click to expand...
 
Back
Top