Query on two last characters

[P Brainard via AccessMonster.com]

I've got a database with a field of id numbers. I want to see all id
numbers that don't end in 01,02,03,04,05,06,07,08,09 ...

for example

55501
44033302
5503331
6040322
800504

I want to see only the 5503331 and 6040322 ... the database is 65,000
records or I'd just go through it manually. Thanks.

 

[fredg]

I've got a database with a field of id numbers. I want to see all id
numbers that don't end in 01,02,03,04,05,06,07,08,09 ...

for example

55501
44033302
5503331
6040322
800504

I want to see only the 5503331 and 6040322 ... the database is 65,000
records or I'd just go through it manually. Thanks.

Where Right([FieldName],2)>10
or whatever number at which you wish to start showing records.

 

[Guest]

= 10 or > 9. He wants to be able to see IDs that end in '1x' presumably;
just not the ones that end in '0x'.

I've got a database with a field of id numbers. I want to see all id
numbers that don't end in 01,02,03,04,05,06,07,08,09 ...

for example

55501
44033302
5503331
6040322
800504

I want to see only the 5503331 and 6040322 ... the database is 65,000
records or I'd just go through it manually. Thanks.

Where Right([FieldName],2)>10
or whatever number at which you wish to start showing records.