between in a query

C

Chris

I have a query where the user can enter two part numebrs and get all of the
data between those two numbers. My question is; is ther a way to get all of
the data between the first number and the second number but also include the
second number?

Thanking you in advance
 
D

Douglas J Steele

By default, the Between operator is inclusive. In other words, it should
return any rows with the the first number, and rows with the last number,
and all rows in between.
 
J

John Spencer

Probably, could you post the query, so we can see what you are doing? Also,
it might be helpful if you gave a short example of the criteria you use and
the records you are NOT getting back. It could be something as simple as
changing the operator from "<" to "<="

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
 
Top