Count Query

[melvis]

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.

 

[Fizzio]

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.

 

[melvis]

Thanks, totally forgot about that.