What happend to the "Total" row in Select Query?

D

dmb

I have Access 2003 and haven't had the need to use Access in a couple of
years. I seem to remember that in earlier versions the Select query included
a "Total" row as well as the usual "Sort", "Show", "Criteria", etc.. Now the
only way I can get the "Total" row to show is to open a Crosstab and then
change it to a Select query. Is there anyway to have the "Total" row always
show in the Select query design mode?
 
K

Klatuu

For some reason, your Totals button is missing from your query tool bar
Try opening a query in design view. Then look for the Tool Bar Options
icon. It is a small down arrow.
If you click on it, you should see "Add or Remove Buttons" Position your
cursor over that and select Query Design. You will see a list of available
buttons. Find and click the Total button.
 
R

Rick Brandt

dmb said:
I have Access 2003 and haven't had the need to use Access in a couple
of years. I seem to remember that in earlier versions the Select
query included a "Total" row as well as the usual "Sort", "Show",
"Criteria", etc.. Now the only way I can get the "Total" row to show
is to open a Crosstab and then change it to a Select query. Is there
anyway to have the "Total" row always show in the Select query design
mode?
Click to expand...

In the menu...

View - Totals

....which is how it has always been.

You do know that showing the Totals row completely changes the type of query
you are creating right? I have always felt that the Totals option had no
business being under the "View" menu. None of the other options under that
menu cause fundamental changes to how your query works, but Totals does.
 
Top