[MS_AccessPros] query help plz

 

I am in the query designer.
The table is tbl_profile and the field is Areyoua

when I test positive for Resident, as below
I DO get what I expect, all record with Areyoua = "Resident"

[tbl_profile]![Areyoua]="Resident"

But what I really want is the inverse, so I put

[tbl_profile]![Areyoua]<>"Resident"

But this results in No records being found?
Is this syntax correct ? and should I be getting all records that
do NOT have "Resident" = to filed Areyoua ?
Terence

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 4

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___