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?

 

[EMP]

Double post

http://www.access-programmers.co.uk/forums/showthread.php?t=101485

^