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

Similar Threads

expression builder NOT 1
Expression Builder; embedded data from other reports in Summary re 4
Report Group Footer DLookUp 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Using expressions in a report to calculate pay 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to Change criteria on a saved query using VBA 0
Expression Builder 0

Top