Results 1 to 3 of 3
  1. #1
    pj13 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    2

    Date Parameters

    I have a report that has 2 parameters, [Start Date] and [End Date]. These parameters work fine when there is data, however if the date range I enter returns no data these date parameters do not show on the report. How can I get them to show even if there is no data? I need the dates to show on the report every time it is run even if there are 0 records.


    Thanks

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Use a form for input instead of parameter prompts. Then you can reference the text boxes on the form and it won't matter whether there is data or not in the results. (you should use an input form instead for most anything and see here for why:
    http://www.tek-tips.com/faqs.cfm?fid=6763)

  3. #3
    pj13 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2012
    Posts
    2
    Thank you, Thank you, Thank you - what I was trying yesterday with forms was not working. I was making it harder than it needed to be.
    Thanks for you time.

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

Similar Threads

  1. Replies: 8
    Last Post: 12-21-2011, 12:50 PM
  2. Enter Wildcards for Date Parameters
    By P5C768 in forum Queries
    Replies: 3
    Last Post: 05-18-2011, 01:42 PM
  3. Replies: 1
    Last Post: 03-05-2011, 03:05 PM
  4. date range form values as parameters
    By cfnieder in forum Forms
    Replies: 8
    Last Post: 08-11-2010, 01:48 PM
  5. Replies: 0
    Last Post: 07-27-2009, 07:51 AM

Tags for this Thread

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