DSum Function from another table than the report's source (1 Viewer)

[jlathem]

Hey guys,

Is there an easy way to put a field in a report that DSum a field from another table than the Report’s Source?

Something like

Customer_ID (from Customer table)
Customer Info (from Customer table)
Total purchases (from the Sales table)

Would the Source of the field be something using the DSum Function?
Something like:
= DSum(“Total_Amount”, “Sales”, WHERE Customer_ID = [Customer_ID]

Thanks for any assistance,
James

 

[pbaldy]

Here's a good reference on the syntax:

http://www.mvps.org/access/general/gen0018.htm

 

[jlathem]

Here's a good reference on the syntax:

http://www.mvps.org/access/general/gen0018.htm

Hi Paul,

Thanks for helping out.

Will DLookup Sum the totals?

James

 

[pbaldy]

No, you still want DSum, but the syntax is the same for all of the domain aggregate functions. They just used DLookup for the examples.

 

[jlathem]

That's what I thought.

Thanks for your help.

James

 

[pbaldy]

No problemo James.