Have at the end of the rpt total up all items in rpt

R

Rhett7660

I did a search but nothing came up for what I am trying to do.. Of course I
could be putting in the wrong wording.......

What I have is a rpt that has
Product Finish///Product Area///Product Type/// Product Name///

The rpt shows a total for each Product Finish.... This is what I want.....
it to do.. I figured that much out...

But on the last page I would like a total of say:
Total for Product Area
Total for Product Type

Can this be done? I have tried doing the sum=[ProductArea] and so on but I
get an error...

What Do I need to do?

Thanks
R~
 
D

Duane Hookom

We don't know what you are "totaling" and what your report grouping levels
are.

Last page usually implies Report Footer. Do you expect totals of something
for each product area and type or just one?

You may need to use a subreport.
 
R

Rhett7660

Roger...

That worked... I guess I had it backwords.....

That worked... sweeet...

Thanks
Rhett

Roger Carlson said:
Try =sum([ProductArea]) in a textbox in the Report Footer section of the
report.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Rhett7660 said:
I did a search but nothing came up for what I am trying to do.. Of course I
could be putting in the wrong wording.......

What I have is a rpt that has
Product Finish///Product Area///Product Type/// Product Name///

The rpt shows a total for each Product Finish.... This is what I want.....
it to do.. I figured that much out...

But on the last page I would like a total of say:
Total for Product Area
Total for Product Type

Can this be done? I have tried doing the sum=[ProductArea] and so on but I
get an error...

What Do I need to do?

Thanks
R~
Click to expand...
Click to expand...
 
Top