ACCESS FEED: RE: [MS_AccessPros] Criteria for query

Minggu, 06 Januari 2013

RE: [MS_AccessPros] Criteria for query

Robin-

Can you paste a sample of the data you're searching? Also include the
complete SQL of your query.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Sunday, January 06, 2013 11:41 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Criteria for query

Even more OOOOPS.

I was wrong. They are still included.

Robin

At 6/01/2013 04:59 PM, you wrote:
>What happened when you tried:
>
>*diverts*
>
>Duane Hookom MVP
>MS Access
>
>----------------------------------------
> > From: robinski@mymail.net.au
> >
> > I have a query with a field for web site page URLs.
> >
> > Some of my URLs are diverts to another page and I need to exclude
> > them from the data.
> >
> > I am using this:
> >
> > Not Like "*robot*" And Not Like "*total" And Not Like "*/diverts/*"
> >
> > But the /diverts/ folder is still included.
> >
> > What have I missed?
> >
> > Many thanks,
> >
> > Robin Chapple
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

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

Yahoo! Groups Links