totals query

T

Tyler

If the totals line isn't showing in your query design
window, you can either click on the sigma symbol in your
tool bar (looks like a weird "E") or you can click View,
Totals. Once you have a totals line you can groupby state
and do a count to get the total number of orders.
 
J

John Nasta

Thanks Tyler. That did the trick!

John Nasta


Tyler said:
If the totals line isn't showing in your query design
window, you can either click on the sigma symbol in your
tool bar (looks like a weird "E") or you can click View,
Totals. Once you have a totals line you can groupby state
and do a count to get the total number of orders.
 
Top