Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can't find out from Access help exactly how the BETWEEN function works.
    If I set up a condition BETWEEN 1 AND 10, is it the equivalent of "Greater than or equal to 1 AND Less Than or equal to 10" or is it "Greater than 1 AND less than 10"?
    Thanks
    Silverback
    Silverback

  2. #2
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='silverback' post='773253' date='01-May-2009 13:36']I can't find out from Access help exactly how the BETWEEN function works.
    If I set up a condition BETWEEN 1 AND 10, is it the equivalent of "Greater than or equal to 1 AND Less Than or equal to 10" or is it "Greater than 1 AND less than 10"?
    Thanks
    Silverback[/quote]
    It's inclusive (ie the former of the two options).
    Waggers
    If at first you do succeed, you've probably missed something.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, Waggers
    Silverback
    Silverback

Posting Permissions

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