Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Parameter in Query (Access 97 SR-2)

    I have date field in a query that tracks an "action" due date. The goal is to get the action item completed, and closed before it becomes overdue. While I do have a "true" overdure report, it only details those records which are overdue. I need to create a report which will show me all records where the due date is from today and during the next 14 days. This way we can hopefully close these items before they show up on the overdue report. I have added the following criteria to the [DueDate] field in the Query, but it ends up returning all records that are 2-3 months from now, and not just those which fall within that 14 day "window".

    >Date()+14

    Thank you in advance for your help.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Parameter in Query (Access 97 SR-2)

    Use
    Between Date() and Date()+14
    in the criteria
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Parameter in Query (Access 97 SR-2)

    Try

    Between Date() And Date()+14

    (As you wrote it, >Date()+14 returns all records with DueDate more than 14 days from now)

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Parameter in Query (Access 97 SR-2)

    Thanks guys. Works great.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •