Showing Total in design

[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

 

[Ted Allen]

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

 

[Guest]

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
.

 

[John Vinson]

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 the Greek Sigma icon (it looks like a sideways M or W).

 

[Guest]

Great..
Thanks.

-----Original Message-----


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


.