Count Query

melvis

Registered User.
Local time
Today, 09:45
Joined
Aug 2, 2002
Messages
40
Hello,

There is probably a really simple answer to this, but my mind has gone totally blank.

Basically I am trying to create a query that will count all of the records in a form that match the criteria I want. For instance, out of 100 children registered, I want to find out the number that are registered blind?

If possible, is there a way in which I can then view only the records that have been returned?

Any help would be greatly appreciated, thanks.
 
In the QBE design grid, click on the Sigma Button (looks like a Poiny E) and it will give you the aggregate functions eg group by, count, max etc.
 
:)

Thanks, totally forgot about that.
 

Users who are viewing this thread

Back
Top Bottom