Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Milwaukee, WI
    Posts
    2

    Question Unanswered: Query two consecutive dates at once

    Currently have a parameter query with
    "Between [Begin Date] And [End Date]:
    but have found that every query needs to check the begin date and the very next date (in case the photo assignment was after Midnight the next day). How can I modify the query to automatically give me the 2 dates without having to type both dates in (begin & end) ?
    Last edited by o0bigs0o; 10-16-02 at 12:57.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Between [Begin Date] And ([Begin Date] +1):

  3. #3
    Join Date
    Oct 2002
    Location
    Milwaukee, WI
    Posts
    2

    Red face

    Voila . . .
    you solved the mystery! Thanx!
    I didn't include the parentheses around the parameter
    when I added the +1
    before my post here.

    Thanx again

Posting Permissions

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