Newbie Counting Help

[Rbutts25]

Please Help Me....

I am trying to count the number of active contractors at the beginning of the month, and then do the same thing for the number of active contractors at the end of the month. I have their end dates and start dates enterred into a table. I would like for the count to update automatically when a date is changed. If someone could help me with this, it would be greatly appreciated.

Ryan

 

[Fizzio]

A little more detail would be appreciated. How do you want to count these contractors?

Do you want to show only the active contractors on a given date?
Where and how do you want to display the information (Form/Query/Report)

 

[Rbutts25]

I would like to be able to create a report that will count the number of number of contractors in the beginning of the month and at the end of month. I am trying to use this as a tracking tool. I figured the best way to do this is to count the number of contractors in the beginning of the month, and then do the same at the beginning of the next month. Thus giving me the beginning and ending totals for the first month. I am completely lost, and I would be extremely greatful for assistance.

Ryan

 

[Fizzio]

All you need is a simple select query with a couple of criteria.
In the start date field you will set the criteria to >= Date()
and in the End date field
<= Date()

In the ContractorID field, set the totals to Count (press the sigma button on the toolbar to enable totals)

You can then run this query at any date and it will give you the number of active contractors on that date.