In Between Question

[PeterL]

I am trying to run a query on a table which has a text product field. The contents of the field might look something like "76050-17001". I need to run a query which limits the range of the product field. Something like >=76050-17001 and <=76050-54000. I thought Access supported a function similar to "Between". Is there another way to write this query?

 

[MichaelRed]

per the ubiquitous {F1} (aka H E L P) between refers to VLAUES, not strings





MichaelRed

 

[PeterL]

Gotcha, how then could I limit the query to records between a text range?

 

[GingerR]

I made a table with a text field with sample data just like yours. I wrote a query, and in the criteria put:

Between "76050-17001" And "76050-54000"

it worked fine.