Re: Troubles with "OR"
- From: "Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2005 10:07:45 +1000
1. "Like" should always be used with wild-cards. Otherwise, use " = " as
Ofer advised.
2. The parentheses are not correct in the WHERE clause. For posting, it is
better to copy and paste (and add new lines for clarity) to avoid typing
mistakes.
--
HTH
Van T. Dinh
MVP (Access)
"aaearhart" <aaearhart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54F1E957-056E-4D24-8F52-24AC0F77199B@xxxxxxxxxxxxxxxx
> SELECT tbl_Projects.[ProjectName],
> tbl_Projects.[ProjectNumber],
> tbl_Projects.[ProjectManager],
> tbl_Projects.[OnsiteLD],
> tbl_Projects.[Onsite Assistant]
> FROM tbl_Projects
> WHERE (((tbl_Projects.[ProjectManager]) Like [Enter last name]
> OR (tbl_Projects.[Onsite LD]) Like [Enter last name]
> OR (tbl_Projects.[Onsite Assistant]) Like [Enter last name]));
>
> I would like to enter the last name only once and have the query search
all
> three fields, but this does not seem to be happening.
>
> any hints?
>
> /amelia
.
- Follow-Ups:
- Re: Troubles with "OR"
- From: aaearhart
- Re: Troubles with "OR"
- References:
- Troubles with "OR"
- From: aaearhart
- Troubles with "OR"
- Prev by Date: Re: iif statement in a select query
- Next by Date: RE: Counting the number of referrals in a report
- Previous by thread: RE: Troubles with "OR"
- Next by thread: Re: Troubles with "OR"
- Index(es):
Relevant Pages
|
