Dlookup in reports

[Donna]

I created a report that groups sales for one particular
product by customer ID. In the customer ID footer on
this original report I created a sum field. I now have
to create a different report that pulls in that sum value
for each customer. I was sure I could use the dlookup
function to pull the values from the original report into
the new one. I can't seem to figure out how to do it.
Since there are multiple entries for each customer for
that product, I could not figure out how to get a total
per customer in a query.

Any ideas how to get that data into the new report from
the original one?

 

[SA]

Donna:

Don't try to use DSum and reference the target report. DSum can only
reference tables or queries.

Rather make a copy of your report's underlying query and then when the new
query is in design view, make it a totals query by clicking the summation ?
icon in the toolbar. For the fields you need a sum for set the column to
sum rather than group by. Base your new report on that query.