query filter help

[taunt]

OK i have some records like r302, and re302. what I'm trying to do i
say filter
the re302 but leave the r302 i have tried this like "R*" not "RE" bu
it changes it to like "R*" <> "RE" and it never works.
when I tell it not

![ect}... it will filter it but not list th
r302 records. How can i have it filter the "R*" records but not th
"RE" records

 

[John Vinson]

OK i have some records like r302, and re302. what I'm trying to do is
say filter
the re302 but leave the r302 i have tried this like "R*" not "RE" but
it changes it to like "R*" <> "RE" and it never works.
when I tell it not

![ect}... it will filter it but not list the
r302 records. How can i have it filter the "R*" records but not the
"RE" records?

LIKE "R*" AND NOT LIKE "RE*"

The AND and OR operators in queries are logical operators, not English
language conjunctions! If you have several conditions which return
TRUE or FALSE, you must string them together with AND (to require that
both arguments must be true) or with OR (to accept the result if
either one of the arguments is true).