Counting in Reports

[Garridon]

I have a report which will report on information for the last three months, counting the total number of records for that month and one that counts the total number overdue for that month.

If I use DCount to count the overdue records, I have to run it off the query, which works fine, except it gives me the total for all three months, not subtotaling for one month. If I try to run DCount off the report, it just gives me a #Error. This is what I'm using:

DCount("[Days Elapsed]","qselTrends","[Days Elapsed]>'0'&quot

Is there another way to do this?

Thanks!

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[mikey69]

Probably best to use the datepart function and then sort or test as necessary.