Filtering a query

[Guest]

Dear Sirs
- I have a query where in the customer Nº field are the following customer
numbers: 43001000-1000, 43001000-3000, 43002000-6000, 43002001-8000,
43001001-9000.
- I don't want to see the Group 43002000-6000 - so everything which start in
the last four digits with a 6 I don't want to see.
Can someone give me the criteria for this?

 

[Allen Browne]

Try:
Not Like "*6???"

BTW, you may need to know that Access cannot match fields consistently where
the data contains a dash. Sometimes it does; sometimes it doesn't, depending
on whether the field is indexed or not.

See:
http://support.microsoft.com/kb/271661/en-us

 

[Guest]

As a field in your query

Left(Right([Customer No],4),1)

as the criteria

<> "6"