Multiple count calculations in 1 query

[tbellomo]

Hello,
I am a fairly versed Access user, but I always have problems with my reporting queries, namely, counting what needs to be counted.
I need to count the number of records created/updated today, yesterday, this week, and year to date. Do I have to create a different query to get each number? Is there a simpler way.

So, to sum up, i have a "created date" field and an "updated date" field, and need to put the count of records created and updated in each time frame in a report. Any advice?

Thanks a million,
tim

 

[danvlas]

You could use DCount("FieldName","TableName","DateCreated Beteween #" & format(StartDate,"mm/dd/yyyy&quot) "# And #" & Format(EndDate,"mm/dd/yyyy&quot) & "#&quot

StartDate and EndDate will represent the range of dates.
You can extend the criteria to whatever you like.

But remember...the more DCounts you use, the slower your query will run...

Good luck


Daniel Vlas
Systems Consultant