Excluding some info. in a Query-Access 2003

B

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
 
J

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.
 
B

BKF

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

Thanks
 
Top