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]").
 
Top