Filter a range of IDs

[eepok]

Hey all,

Using the built-in query builder, how can I filter the query by a user defined range of record IDs?

I know about the "like" command in the criteria field, but I don't know how to implement a range of criteria (IDs 27-54).

 

[georgedwilkinson]

between

where ID between 27 AND 54

 

[pbaldy]

I would have the user enter the 2 values in form controls, and use a criteria of

Between Forms!FormName.FirstControl And Forms!FormName.SecondControl

 

[eepok]

I would have the user enter the 2 values in form controls, and use a criteria of

Between Forms!FormName.FirstControl And Forms!FormName.SecondControl

Hey baldy,

I just wanted to write back and let you know that I researched a bit of the vocabulary often taken for granted (the term "control" as a noun is still new to me), learned what you said, and implemented your suggestion which works perfectly.

I would give you another boost to your points, but I have to wait before someone else has to help me before I can give you credit... again. =P

 

[pbaldy]

Your thanks is enough. Glad it worked for you.