Results 1 to 2 of 2
  1. #1
    mac322n is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Posts
    1

    Checking Date Range in Multiple Fields

    I have a table with 18 fields and 15 of them are date fields (mm/dd/yy format). I want the user to enter a Start Date and End Date on a form. Then I want a query to check the date fields and return any record that has a date field that fits the date range criteria. Thanks for your help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,972
    Would need same filter criteria under each field but on separate line to invoke the OR operator (looks like stair steps).
    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: 4
    Last Post: 02-03-2014, 12:16 PM
  2. Replies: 12
    Last Post: 01-23-2014, 03:24 PM
  3. Query to Pull from Date Range & Check 2 Areas
    By esh112288 in forum Queries
    Replies: 9
    Last Post: 11-12-2013, 10:05 PM
  4. Replies: 3
    Last Post: 10-25-2012, 10:04 PM
  5. Date Range Report with Multiple Date Fields
    By StevenCV in forum Reports
    Replies: 13
    Last Post: 02-29-2012, 08:29 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