In a query, I use a field from another table as criteria.
If I use the table column address, it works fie.
But, when I prefix it with 'NOT' or 'NOT LIKE', it does not filter the records. The query displays all records.
Is NOT or NOT LIKE the correct syntax?
Thanks
Guru
If I use the table column address, it works fie.
But, when I prefix it with 'NOT' or 'NOT LIKE', it does not filter the records. The query displays all records.
Is NOT or NOT LIKE the correct syntax?
Thanks
Guru