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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a "like" query between two fields from two different tables... 2
Create a query for specified text in a field 2
query excluding listings from table 2
Query Not working with newly imported table 1
Combining queries and expressions to populate and select info 2
Query to see only first several records 1
Sort order by customer name not working in query 5
Parameter Query No Results - Needs to Auto Create Record 4

Top