Hi, I hope someone can shed a light on this - seems so simple yet the answer alludes me.
This works in a form query:
SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)="Accounts"));
However, I want to have the record source exclude "Accounts" from the field Category, I have no records displayed.
These are the two methods I tried.
SELECT Contact_People.* FROM Contact_People WHERE ((Not (Contact_People.Category)="Accounts"));
SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)<>"Accounts"));
Seems to me to be correct, so what am I missing.
H
This works in a form query:
SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)="Accounts"));
However, I want to have the record source exclude "Accounts" from the field Category, I have no records displayed.
These are the two methods I tried.
SELECT Contact_People.* FROM Contact_People WHERE ((Not (Contact_People.Category)="Accounts"));
SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)<>"Accounts"));
Seems to me to be correct, so what am I missing.
H