I'm using the NOT expression to exclude certain records in a query. I can't seem to get it working using more that one exclusion. For example I would like to return records for all sales people excluding............
When you do your query grid, before you save it, switch to SQL to see how it makes the list.
Let's say your name field is called WholeName and that your spelling was exactimundo on the names. (Spelling of the individual names must be exact for this to work anyway.)
If you see OR instead of AND in such a clause, edit the SQL to correct the text to AND. Then switch back to the query grid to see what it did to you. Don't bother to save anything until you have the AND in place rather than the OR in the SQL view of the query.
Let me guess... you tried this in a query grid, listed the names, and nobody got excluded, right? That is because the query grid is implicitly based on OR, not AND - but in this case you really wanted AND, not OR, so the query grid fooled you.
Let me guess... you tried this in a query grid, listed the names, and nobody got excluded, right? That is because the query grid is implicitly based on OR, not AND - but in this case you really wanted AND, not OR, so the query grid fooled you.