between in a query

[Guest]

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

 

[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.

 

[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