Thanx Duane
GOT IT!!, I hate Nulls :)
Terence
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
>
> 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@...
> >
> >
> > 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
> > >
> >
> >
> >
>
Tidak ada komentar:
Posting Komentar