T ttp Oct 12, 2008 #1 If you add the total row to the design grid, how do you use expression from the drop down selections?
If you add the total row to the design grid, how do you use expression from the drop down selections?
J John Spencer Oct 12, 2008 #2 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))
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] Oct 12, 2008 #3 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.
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.
