Query must filter out records beginning with text "192"

23 Feb 2005 11:19 AM

Rene Wennekes

SELECT webstats.Tijd, webstats.Computer
FROM webstats
WHERE (((webstats.Computer)<>"192.168.0.204"));

if i put * after 192 i get a syntax error.
with left and ;3 also.

I want to filter out what begins with192

How do i do that?

Rene

23 Feb 2005 1:29 PM

AlCamp

Show quote

"Rene Wennekes" <rene.wenne***@wolting.nl> wrote in message
news:%23R1ROmZGFHA.3728@TK2MSFTNGP14.phx.gbl...
> SELECT webstats.Tijd, webstats.Computer
> FROM webstats
> WHERE (((webstats.Computer)<>"192.168.0.204"));
>
>
> if i put * after 192 i get a syntax error.
> with left and ;3 also.
>
> I want to filter out what begins with192
>
> How do i do that?
>
> Rene
>

23 Feb 2005 1:43 PM

rico

TRY "192.???.?.???"

plus should work without the backets

Show quote

"Rene Wennekes" wrote:

> SELECT webstats.Tijd, webstats.Computer
> FROM webstats
> WHERE (((webstats.Computer)<>"192.168.0.204"));
>
>
> if i put * after 192 i get a syntax error.
> with left and ;3 also.
>
> I want to filter out what begins with192
>
> How do i do that?
>
> Rene
>
>
>

23 Feb 2005 1:57 PM

rico

Sorry didn't realise, also <> will not work for a text field, try this

SELECT webstats.Tijd, webstats.computer
FROM webstats
WHERE webstats.computer NOT LIKE "192*";

HTH

rico

Show quote

"rico" wrote:

> TRY "192.???.?.???"
>
> plus should work without the backets
>
> "Rene Wennekes" wrote:
>
> > SELECT webstats.Tijd, webstats.Computer
> > FROM webstats
> > WHERE (((webstats.Computer)<>"192.168.0.204"));
> >
> >
> > if i put * after 192 i get a syntax error.
> > with left and ;3 also.
> >
> > I want to filter out what begins with192
> >
> > How do i do that?
> >
> > Rene
> >
> >
> >

23 Feb 2005 1:52 PM

Ed Robichaud

I think you mean that you want to "filter on" i.e. that your query returns
all records beginning with 192. If so, use the Like function in your
criteria; see Access help for syntax.

Like("192*")

-Ed

Show quote

"Rene Wennekes" <rene.wenne***@wolting.nl> wrote in message
news:%23R1ROmZGFHA.3728@TK2MSFTNGP14.phx.gbl...
> SELECT webstats.Tijd, webstats.Computer
> FROM webstats
> WHERE (((webstats.Computer)<>"192.168.0.204"));
>
>
> if i put * after 192 i get a syntax error.
> with left and ;3 also.
>
> I want to filter out what begins with192
>
> How do i do that?
>
> Rene
>