Using Total Row in Design Grid

  • Thread starter Thread starter ttp
  • Start date Start date
T

ttp

If you add the total row to the design grid, how do you use expression from
the drop down selections?
 
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))
 
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.
 

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

What does "expression" refer to in the Totals list in a Query? 5
VB6 Component Issue with TDBGRID 0
Use result of expression in another expression?? 9
IF ISNUMBER FIND in query design expression 1
Bug? Using full identity expression in any arbitrary column works 4
design grid total line question. 2
Totals query and Memo field 3
Show / hide design grid 3

Back
Top