Search String

[playsted]

I have a serach set up that searchs by about nine fields; however, I want to add a sting that can search by a range of numbers and return all the results within that range.

Andy

 

[Trevil]

How abouth the following?
WHERE (((tbl1.fld1)="a")) OR (((tbl1.fld1)="b")) OR (((tbl1.fld1)="c")) OR (((tbl1.fld1) Between 1 And 100));

Code: Where the vision is often rudely introduced to reality!