Using expression builder in a report

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.
 
G

Guest

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 3
How to Use Expression Builder to display Query Results? 1
Strrange report => query builder problem 1
Report expression builder parameter value 3
Adding a return in an expression builder 2
Expression in Control giving error 1
Placing Headers in report that match group expression 2

Top