Follow up
The filed is text, not required, with no default value
Therefore I assume it's Null ?
so I ran a query with Isnull, and sure enough ,the fields are null value.
But I still need this to work in testing for "Resident" even with the null scenario ?
will I need to put a default value at the table level to get around this ?
Terence
--- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar