ekendricks

I hope this question is in the right forum.

Doing a report in MS Access (Desktop... Not Web Based). I am listing items by date order and need dates to run 1 thru 31. I'm using "Count" which increments perfectly to show just the date. My problem is, I would like to populate the report to show all dates, even from the beginning of the month. ie: On the first day of the month, there is one line, and the second day of the month, two lines, etc. Can I populate the report to show the count from 1 to 31 (lines) even tho the 3rd thru 31st is blank?

Thanks
Ernest

Webforumz Staff

You'd probably want to use the NZ function to replace your null values with zeros, then when you add them you'll get 0 instead of null as a sum.