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~
 

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

Top