[AccessD] Query error

Hi Charlotte

Not quite. BETWEEN means literally "between" which means that you can switch the values of the parameters. 
Thus if:

  a = 1
  b = 4

then

  x between a and b 

will return x of 1, 2, 3, and 4, and so it will if you switch the values:

  a = 4
  b = 1

To simulate that exactly with >= and <= you will need an extended construction like this:

  (x >= a and x <= b) or (x >= b and x <= a)

/gustav


>>> cfoust at infostatsystems.com 12-11-2009 22:53 >>>
Between is merely another way of saying >= and <=.  You can always substitute one for the other.

Charlotte Foust