Re: How to use operators Like and Not Like together?

[Stuart McCall]

Change this:

WHERE (((ROOT_AE_P_PR O_E.PROPOSAL) Not Like"*02312") AND

to this:

WHERE Not ROOT_AE_P_PRO_E .PROPOSAL Like"*02312" AND

(I removed the parens for clarity - if you type the line in as above, Access
will put them back in)

[jfcby]

Re: How to use operators Like and Not Like together?

>
WHERE Not ROOT_AE_P_PRO_E .PROPOSAL Like"*02312" AND
>

Above Did not work.

But this did work:

WHERE ROOT_AE_P_PRO_E .PROPOSAL Not Like"*02312*" AND

Thanks for your help,
jfcby