Query Sums in a Report

[bellis]

Can I sum a query in a report?

In my report, I tried the below and got an error.

DSum("[QueryName]![Field1]","[QueryName]","[QueryName]![Field2]=Value")

Thank you in advance.

 

[pbaldy]

That should work, providing the actual syntax is correct:

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

You would also need to add =:

=DSum(...)

 

[bellis]

I still can't get it. Probably a syntax issue, as you said.

I tried copying the syntax from the link you sent. Any ideas? I'm stumped!

=DSum("[QueryName]![Field1]","[QueryName]","[QueryName]![Field2]='String'")

This is possible to do on all Query fields right?

 

[pbaldy]

Try

=DSum("[Field1]","[QueryName]","[Field2]='String'")