tahirih
asked on
Access - query with "not equal"
Hi,
In a Make Table query - I am using <>"with" to indicate creating a table that does not include rows with word "with"
However, this is not working - any suggestions/
Thank you.
In a Make Table query - I am using <>"with" to indicate creating a table that does not include rows with word "with"
However, this is not working - any suggestions/
Thank you.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Is "with" the only word in the field you are looking at? The specification <> "with" for a field will exclude only records where "with" is the entire content of the field. If you want to exclude records containing "with", try this instead:
Not Like "*with*"
Not Like "*with*"
ASKER