RE: [MS_AccessPros] Re: query help plz

Terence Terence,

If you want to include Nulls you can set the query WHERE clause to something like:

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

Duane Hookom

MS Access MVP

________________________________
> From: buffalome90210@yahoo.com
>
>
> 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<mailto:MS_Access_Professionals%40yahoogroups.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
> >
>
>
>

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/