Using Total Row in Design Grid

T

ttp

If you add the total row to the design grid, how do you use expression from
the drop down selections?
 
J

John Spencer

Expression usually gets used when you want to do a calculation of some
type involving one of the aggregate functions.

For instance the following would get tagged as an expression.

Count(IIf([tableFlow_1].[flowRate]>20,1,Null))
 
B

Bob Barrows [MVP]

ttp said:
If you add the total row to the design grid, how do you use
expression from the drop down selections?
Click to expand...

If you know what the sql needs to look like, switch to SQL View and enter it
directly. Then switch back to Design View to see how you were supposed to do
it in the grid.
 
Top