Using expression builder in a report

R

Ruben

I am using expression builder in a report which needs to retrieve the SUM of
a field from a query. This does not seem to be working. I keep getting
errors...#NAME? I am using the query's field as the control source.
Can anyone help me? I've tried everything I know.
 
D

Duane Hookom

The Sum() aggregate function only works on fields/expressions from the
report's record source. You may be able to use DSum("[field to sum]", "[Query
Name]").
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top