DSum expression w/query as Domain

[hforman]

Help! I've been struggling with this expression for days! It's in an MS Access report:

=DSum("[Estimated Commissions]","Producer tracking query","[Status]='Closed Successfully'"AND"[Activity Type]='HAPR'&quot

When I reference the table as the domain, it works, but it gives me all the values in the table that meet the criteria. But I'm running this report from a query, I only want records in a certain date range, etc. When I reference the query (Producer tracking query) I get an #Error result.

Can you use a query as the domain in a DSum expression, and if so, how?

 

[jebry]

Hi!

I don't know if it is the problem or not, but you don't need the quotes around the And:

=DSum("[Estimated Commissions]","Producer tracking query","[Status]='Closed Successfully' AND [Activity Type]='HAPR'&quot


This should get you what you want.

hth
Jeff Bridgham
bridgham@purdue.edu