Counting Records

[Clownfish1980m]

I want to figure out how to count the number of records that exceed greater than 30 days. I have a report that takes a date when the project starts and using=Date()-[1st Date] as the data source to give me the number of days from the time the project started to today. This lets me know how long the project is taking. What I want to do is create a report that counts how many projects are greater than 30 days and another field showing how many are <30 days for each site. Any suggestions? Ken

 

[missinglinq]

As the Control Source for an unbound textbox, on your form, you can use the DCount() function against your RecordSource, using a Where statement that shows how many records show a date over 30 days old, and do the same thing to show how many are under 30 days old.

And don't forget records that are exactly 30 days old!

Linq ;0)>