Sorting Aggregate Control

B

BevC.

=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])
 
M

Marshall Barton

BevC. said:
=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])


First, replace text52, text145, etc with the expression in
the corresponding text box. E.g. =Nz(x+y) + Nz(x*z) + ...

If x, y and z are fields in the report's record source
query, then you can use that expression in Sorting and
Grouping.

If any of the expressions you have in the other text boxes
are aggregates (Count, Sum, etc), then you must use that
expression in the report's record source query.
 

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