auto number field

[jewel]

hi all

I have a table with auto number - long integer

I want to run a query just bringing out say 30 records that are not in consecutive order

eg id no 32, next id no 37

how do I put this in my criteria field

If I put it in "" it looks at it as a text field and then tells me data type mismatch

can I do this?

thanks
Dianne

 

[GingerR]

31 or 37 or 45 or.....

 

[jewel]

thank you Ginger I couldn't for the life of me think what to do, and I have done it lots of times before - just a blank. much appreciated