queries with over 100 criteria (1 Viewer)

[bl0u2011]

Hello everyone

I am just trying to write a query by a code of table
i would like to pick up any record with id number betwee 1-99 and 200-299
i try typing them in manually but access wouldn't cope

any idea of how i can achieve it please
Many Many Thanks
Si

 

[Rabbie]

You could try having criteria like (IDnumber between 1 and 99) Or ( IDnumber Between 200 and 299)

 

[bl0u2011]

Oh yeah, that works brilliantly
Thanks for that