using the between operator

[monsterman66666]

I am trying to display 2 sets of data. I one field and I want to be able to say between 1 and 2; Is there any way possible to do accomplish this?


Thank You

 

[ETID]

In a query?


it would be a criteria of

>=1 and <=2.... or >1 and <2

 

[reply]

yes a query or vba.
Here's my scenario;


The field name is location.

I want to use this as an example.

I want to know FROM location TO location.

thank you

 

[cmmrfrds]

Did you try
Where Location between 1 and 2
and it didn't work?

 

[monsterman66666]

yes i have.


but i have two text boxes to enter the code for don't I?

 

[cmmrfrds]

Are you asking, how to get the variables from the text boxes into the sql statement? There are many ways to do this depending on what you are comfortable with. Basically, the easiest is to collect the variables on first form and then open the second form with the variables as part of the filter on your recordsource.