Report

[Guest]

Hi,
I have a report that pulls up the names of products form a table and the
price for the product. They are arranged using sorting and grouping. Each
group has a total.....=nz(Sum([Total Price])).... in the group footer. The
problem is I want the total of all the products in the group I just dont want
them all visible. However, If i use criteria to view the products I only want
to see then =nz(Sum([Total Price])) doesnt work because It wont be a total of
ALL the products. How can I get a total of a list of products while only
viewing certain ones on the report?


Thanks

 

[tina]

try using the DSum() function to sum the prices directly from the table, or
from a query that pulls all the specific records you want summed. see the
DSum() Function topic in Access Help for an explanation of how it works.

hth