Counting dates

[chef_tim]

Okay, this is gonna be weird What I'm looking to do is count the dates a preticular training task was accomplished. However, I do not want the dates that are expired to be counted. I will be running this off of a quiry that shows the "due date" of each task. I really have no idea where to start . Many thanks, Tim

 

[FoFa]

Basically it sounds like you want to group by your task, count the dates in the select and widdle out those you do not want in your criteria.

 

[chef_tim]

That sounds about right. After their counted then I can divide by the number for personnel to get a percent trained. Thanks, Tim