Showing Total in design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am trying to get "Total" to show on my query when in
design mode. I did it once before but I cant remember
how..
Thanks
 
Just right click in the design grid area of the query and
you should see an option for Sum Totals. This will add a
line to your query for Group By or Summary options. I'm
sure there's a way to do it from the menu also, but I
always just right-click so I'm not sure where it would be.

If you right-click and don't see the option, try right-
clicking in another area (I think I usually just right-
click in the blank area of the design grid by the
criteria line).

Hope that helps. Post back if you still don't see it and
I'll give a little more detailed description.

-Ted Allen
 
Thanks but i still dont see it.
-----Original Message-----
Just right click in the design grid area of the query and
you should see an option for Sum Totals. This will add a
line to your query for Group By or Summary options. I'm
sure there's a way to do it from the menu also, but I
always just right-click so I'm not sure where it would be.

If you right-click and don't see the option, try right-
clicking in another area (I think I usually just right-
click in the blank area of the design grid by the
criteria line).

Hope that helps. Post back if you still don't see it and
I'll give a little more detailed description.

-Ted Allen
.
Click to expand...
 
Hello,
I am trying to get "Total" to show on my query when in
design mode. I did it once before but I cant remember
how..
Thanks
Click to expand...

Click the Greek Sigma icon (it looks like a sideways M or W).
 
Back
Top