How to count records?

[Anna Anna]

End Date // Full Time // ID

15/01/03// Yes// 11
16/01/03// Yes// 8
17/02/03// Yes// 3
19/02/03// Yes// 4

Hi!
This is example of the result of my query. How do I calculate the number of people working Full Time? I need this number for further calculations. I was trying ‘count’ for ID field but it was showing 1 for every record or 2 or more if there was the same date. Please help! I hope it is not too complicated.

Anna

 

[Anna Anna]

Hi again!
I think I figured something out but I need your opinion if it makes any sens: I created a new query based on the one that you have senn in my example but I didn't include ' End Date' field. Then I used 'count' for 'ID' field and I got right number. I am wondering if I am "celebrating" too fast or I can use this "trick" in my futher calculations?
I count on your opinion.
Thanks
Annna

 

[Pat Hartman]

It isn't a trick.

Select Count(*)
From YourQuery
Where FullTime = Yes;