MS Access Reports

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.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices




Closed Thread
 
LinkBack Thread Tools
  #1  
Old May 3rd, 2004, 17:06
Junior Member
Join Date: Aug 2003
Location: USA
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!

  #2  
Old May 3rd, 2004, 19:54
Most Reputable Member
Join Date: Jul 2003
Posts: 1,856
Thanks: 0
Thanked 0 Times in 0 Posts
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Closed Thread

Tags
access, reports

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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


All times are GMT. The time now is 05:15.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved