Selection criteria

#1 (**permalink**) 19-Nov-2005, 21:59 PM

I have created a query and would like to select records based on the
following criteria:

Select all records where the field has "holiday" or "vacation" but exclude
those which have "public holiday".

Is it possible to put the criteria on one line or would I have to use two
lines -
Like "Holiday*" And Not Like "Public Holiday*"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7713-selection-criteria.html
Like "vacation*"

Al
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7713

*

#2 (**permalink**) 19-Nov-2005, 21:59 PM

(Like "Holiday*" And Not Like "Public Holiday*") Or Like "vacation*"

Access may well change that to two criteria rows the next time you open it
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7713
in design view, though. The query designer does that sometimes, and as far
as I know there isn't any way to stop it, short of never opening the query
in design view.

I'm not sure that it really makes any difference in this scenario, though?

--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7713
Brendan Reynolds

"PE" wrote in message
news:%23msGLUC7FHA.1032@TK2MSFTNGP11.phx.gbl...
>I have created a query and would like to select records based on the
> following criteria:
>
> Select all records where the field has "holiday" or "vacation" but exclude
> those which have "public holiday".
>
> Is it possible to put the criteria on one line or would I have to use two
> lines -
> Like "Holiday*" And Not Like "Public Holiday*"
> Like "vacation*"
>
> Al
>
>

#3 (**permalink**) 19-Nov-2005, 21:59 PM

Yes Access does change the criteria to two row.

The problem I had with two rows was that I had to key in dates to and from
(to select records between certain dates) twice, but after doing what you
suggested I only have to key in the dates once, even though Access has split
the criteria to two rows!!

Thanks for your help.

"Brendan Reynolds" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7713
news:%237diLfC7FHA.3660@TK2MSFTNGP09.phx.gbl...
(Like "Holiday*" And Not Like "Public Holiday*") Or Like "vacation*"

Access may well change that to two criteria rows the next time you open it
in design view, though. The query designer does that sometimes, and as far
as I know there isn't any way to stop it, short of never opening the query
in design view.

I'm not sure that it really makes any difference in this scenario, though?

--
Brendan Reynolds

"PE" wrote in message
news:%23msGLUC7FHA.1032@TK2MSFTNGP11.phx.gbl...
>I have created a query and would like to select records based on the
> following criteria:
>
> Select all records where the field has "holiday" or "vacation" but exclude
> those which have "public holiday".
>
> Is it possible to put the criteria on one line or would I have to use two
> lines -
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7713
> Like "Holiday*" And Not Like "Public Holiday*"
> Like "vacation*"
>
> Al
>
>