Results 1 to 2 of 2
  1. #1
    AAA is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3

    Exclamation Multiple date ranges on report

    I am trying to generate a report that requires the user to enter a date range once, and that date will then be used to generate several sub-reports based on queries. For example I have 7 tables that have a field named: [DateIn]. I want to use a query to calculate how many records have been created within the date range entered for each table and then summarize this on a report. I only want the user to enter the date range once. Thank you :-)

  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,521
    I wonder about the design, but you can create a form for the user to enter the dates on, and have the queries point there.
    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. Searching for Date Ranges
    By phd42122 in forum Access
    Replies: 2
    Last Post: 05-07-2012, 07:20 AM
  2. Replies: 1
    Last Post: 01-10-2012, 10:12 PM
  3. Working with date ranges
    By Acegundam in forum Queries
    Replies: 3
    Last Post: 11-04-2011, 02:04 PM
  4. Date ranges using Calendar control
    By LilMissAttack in forum Forms
    Replies: 8
    Last Post: 08-25-2011, 10:04 AM
  5. Select Query Using Different Date Ranges
    By Hemi426 in forum Queries
    Replies: 3
    Last Post: 07-26-2010, 01:06 PM

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