Getting a total, not a list

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

I have a table that has 4 columns

Day Date Time Successful

I already have a query telling me how many successful and unsuccessful
record I have out of the total number of records recorded. I now have a
query tellin me how many out of those unsuccessful records were entered
before 10am. The problem is that its giving me a list. I need just a
total. How should I set up my query?


Dominique
 
In your query you want to select the Totals button up top or go to
View->Totals. This will give you an extra line and by default I believe it
will place "Group By" in that row for all fields. Since it sounds like you
just have the one field, change the "Group By" for that field to "Count."
So basically if all you want is just one number, this will give it to you.
HTH

Bill
 
Back
Top