Using expression builder in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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