HOW DO I SET UP A "DOES NOT EQUAL" FORMULA IN DATABASE?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a query for information based upon some invoices and want to
eliminate those invoices that contain specific words in a particular field.
How do I do that?
 
Mark said:
I am running a query for information based upon some invoices and
want to eliminate those invoices that contain specific words in a
particular field. How do I do that?
Click to expand...

WHERE FieldName Not Like "*SomeWord*"
AND FieldName Not Like "*SomeOtherWord*"
etc...
 
You must log in or register to reply here.

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

GROUP BY question 1
manual deletion of records in datasheet based on joined tables 5
How do I display 1 line per Invoice Summary w/totals from Invoice Detail ? 4
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Criteria not working on expression field in query 3
Searching for Missing Data 1
How to choose later of two or more records 4
Need query to filter out duplicates based on another column 4

Back
Top