Anyway of adding like a count field to a query please?

[ignite]

Is there anyway I can add a sort of count field to my query, for example what I require is the result of my query to include a column which counts the rows in the queries.

For example:

PositionID NumOfVotes Count
5 5 1
6 2 2
etc.

Any advice please?

 

[wazz]

use the Totals button in the query design. add PositionID to the grid a second time, select Count (instead of Group By) in the Total row.