Results 1 to 3 of 3
  1. #1
    Troxs is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    7

    Making a report with a every day of the month even if the record doesn't exist

    TLR -- How can I make a report show a full months of data if the table doesn't contain a record for each day?



    We run a test randomly throughout the month, and the state would like a report of those numbers. However, in typical government fashion the report must have all dates of the month. How can I have the report show all dates? Do I need to make a query to populate the table? If so, how?

    Thank you

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Found something here that actually works. If you follow it through, you could add the second query to your query behind your report.
    http://www.access-programmers.co.uk/...ad.php?t=91752
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    another way - is simply to add a Calendar table to the database. The table is simply a list of all dates - 1 column. Like the Mayans you have to figure out how far in time you want it to go. Typically you can find these in csv or excel format online.....

    Then join this table into your query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. record doesn't exist
    By slimjen in forum Forms
    Replies: 7
    Last Post: 08-13-2014, 11:07 AM
  2. Replies: 4
    Last Post: 12-14-2012, 06:33 PM
  3. VBA to create PDF and folder if doesn't exist!
    By crxftw in forum Programming
    Replies: 2
    Last Post: 08-08-2011, 08:53 AM
  4. Append if record doesn't exist
    By Lorlai in forum Queries
    Replies: 1
    Last Post: 06-14-2011, 06:38 PM
  5. Form doesn't exist
    By Back2Basics in forum Access
    Replies: 1
    Last Post: 02-01-2010, 11:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums