Results 1 to 4 of 4
  1. #1
    That_Guy is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    13

    Query Help Please - Criteria: <Date()+90 And >Date() Or: <Date()+90 >[Date Data]


    I need to edit an existing query to provide date before 1/31/2013. Currently the query is setup as:

    Criteria: <Date()+90 And >Date()
    Or: <Date()+90 >[Date Data]

    Is this looking at date 90days before this date and 90 days ahead? Or only 90 days ahead? If it is doing 90 before and ahead I need a solution for 90 days before and until 1/31/2013. Any help is appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is important about 1/31/2013? You will have to modify query when 1/31/2013 arrives?

    You want records where [Date Data] is between 90 days prior to 1/31/2013 and up to 1/31/2013?

    Maybe:

    [Date Data] BETWEEN #1/31/2013# - 90 AND #1/31/2013#
    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
    That_Guy is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    13
    The query will be looking at a table that has dates beyond 1/31/2013. I do not want to include any data with dates after 1/31/2013

    Is the current query looking at records 90 days prior to today's date? If so, then maybe what I want is [Date Data] BETWEEN Date () - 90 and #1/31/2013#

    I have no idea if that ^^ would even function.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Looks like it will to me. Try it.
    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: 15
    Last Post: 04-06-2012, 10:57 AM
  2. Replies: 3
    Last Post: 04-01-2012, 01:40 PM
  3. query to update a date based on another date
    By tkendell in forum Access
    Replies: 3
    Last Post: 06-29-2011, 09:32 PM
  4. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  5. Replies: 2
    Last Post: 07-31-2009, 06:56 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