Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    20

    Exclamation Unanswered: criteria between two dates

    I understand how to create a criteria for last month in a query but what if you want last month to be say January 2nd to February 1st. Can this be done are do you have to enter the dates with the between and function.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Criteria between suggests you are using the query designer, which is something I don't do. It is however the right way to query a range. Just make certain you refer to the earlier date first.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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