Excluding some info. in a Query-Access 2003

[BKF]

I have a query that reports on customer names from my database/table.
I have a test customer called ABCs that appears in my query!

How can I exclude the ABCs customer from appearing and only see my real
customers in the query results?

Thanks

 

[Jerry Whittle]

In the criteria for that field, put the following:

<> "ABCs"

 

[BKF]

ABCs still appear except further down in the list produced by query?

 

[Jerry Whittle]

Are you talking about some text that is exactly "ABCs" or something else?

Please post the SQL statement that is showing these records but further down.

 

[BKF]

Jerry, I tried this and it seem to work:
Not Like "*ABCs*" in the criteria field.

Thanks