I have an Access query & I need to put multiple "not like" criteria into one field. Using more than one line does not work & putting or between the criteria does not work. Can anyone help?
by 
Joslady
ANSWERS: 1
-
Have you tried the 'and' conjunction? Multiple 'Not Like' criteria wouldn't work with just "or", because you need to use all of your 'Not Like's together to screen out the values you don't want. So, for example: [FName] not like "*Bob*" and [FName] not like "*Carol*" and [FName] not like "*Ted*" and [FName] not like "*Alice*" would screen out Bob & Carol & Ted & Alice. It would allow Robert/Roberta, Caroline, Theodore & Alicia.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC