adding up totals column in report

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

Al Campagna

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

Haroon

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.
 

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

Adding Fields 2
Report Totals 3
Summary Report 2
Row and Column Totals on a Report 1
Child/Master Link in Report with SubReport 2
Report Totals 2
Sub Query? 2
Grand Total for a calculated column - Access 2007 1

Top