Results 1 to 4 of 4
  1. #1
    IzzyKap is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    10

    Print StartDate and EndDate in Report after specifying during report generation

    I have built a Report based on a query and group/sort where StartDate and EndDate are entered by a user. It works fine. However, I wasn't able to figure out how to display the selected Start and End dates on the report. When I put it in a header, there are additional prompts to enter the dates after the initial entry. Any suggestions are greatly appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    How are the dates entered by user - query parameter input prompts? I NEVER use input prompts. Have users input into textboxes on form. Query can reference the textboxes as parameters. Textboxes on report can reference the form textboxes. Form must remain open when the report executes. There are other methods to pass info to report but that is probably the simplest.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    IzzyKap is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    10
    Quote Originally Posted by June7 View Post
    How are the dates entered by user - query parameter input prompts? I NEVER use input prompts. Have users input into textboxes on form. Query can reference the textboxes as parameters. Textboxes on report can reference the form textboxes. Form must remain open when the report executes. There are other methods to pass info to report but that is probably the simplest.
    Thanks. I was using input prompts. I'll look into using forms.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 18
    Last Post: 01-31-2013, 01:18 PM
  2. Linking data fr report generation
    By DPCarusone in forum Reports
    Replies: 1
    Last Post: 02-08-2012, 09:30 AM
  3. Report Generation from with a Form
    By amangupts in forum Reports
    Replies: 29
    Last Post: 07-22-2011, 08:40 AM
  4. Report Generation
    By Lorlai in forum Reports
    Replies: 5
    Last Post: 07-01-2011, 11:13 AM
  5. Replies: 5
    Last Post: 06-17-2011, 11:35 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