Results 1 to 4 of 4
  1. #1
    DEFT is offline Novice
    Windows XP Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    5

    Multiple Reports with multiple date parameters into 1 report

    Hi all,



    So I am trying to create one weekly summary report that pulls information from 5 other reports (that each detail one specific type of information) so that my team can review all of the information needed for the week in this one report. However, each of the separate reports are based off of separate queries which all include the date parameter--> Between [Enter the start date:] and [Enter the end date:] . What I would like to do to make the process easier for my team to be able to run the one summary report themselves is to only have them enter the date parameter one time (and for it to pull information for that data range from each of the separate report into the one summary report) and for the date range to populate into the report so they would know what date range the information is being pulled from. However, now, every time the one summary report is run, it requires we enter the dates five different times (one time for each report being pulled into the one summary report) and I can't figure out a way for the dates to populate into the report itself. Is there a way to do this?

    Any information would be helpful! Thank you so much for you time and advice!


    Best,
    DEFT

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Most of us use forms to gather user input, and that would certainly solve your problem. Instead of:

    [Enter the start date:]

    You'd have

    Forms!FormName.TextboxName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    DEFT is offline Novice
    Windows XP Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    5
    Yes, I've seen that used in different forum posts. However, in using this method, would I create a form with a textbox, and then link it to fill out all of the queries that feed into the reports? Sorry if I am not understanding your response. I am still new to Access and have attempting to learn as much as I can.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    There are many ways to implement it, the key being that the user enters the required parameters on a form instead of using bracketed criteria. You could have a form with two date textboxes and a button. The button opens the report.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Multiple Reports in 1 report
    By 10Pints in forum Access
    Replies: 15
    Last Post: 08-13-2015, 01:31 PM
  2. Replies: 10
    Last Post: 02-14-2015, 10:41 AM
  3. Replies: 1
    Last Post: 06-06-2014, 08:26 AM
  4. Replies: 2
    Last Post: 04-12-2012, 05:16 PM
  5. Multiple Reports within Report
    By jakelufkin in forum Reports
    Replies: 0
    Last Post: 08-31-2009, 08:42 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