This is a discussion on "MS Access Reports" within the Databases section. This forum, and the thread "MS Access Reports are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
MS Access Reports
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
|||
|
|||
|
MS Access Reports
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 |
|
|
|
#2
|
|||
|
|||
|
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.
|
![]() |
| Tags |
| access, reports |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ASP Multi users Access to Microsoft Access | ish | Classic ASP | 0 | Apr 26th, 2007 20:05 |
| Airline MAintainance Reports | Accurax | Webforumz Cafe | 3 | Jan 10th, 2007 09:23 |
| Joining Text Field Values in Access Reports??? | JKidd32 | Databases | 0 | Jan 19th, 2006 12:57 |