Re: Show all records in query if conditions is false

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: peregenem@xxxxxxxxxxxx
Date: 12 Aug 2005 08:34:45 -0700

John Spencer (MVP) wrote:
> Field: ProjectCreator
> Criteria: LIKE IIF(CurrentUser() in ("btibbs","csarmiento"),"*",CurrentUser)

Alternatively (in SQL code):

ProjectCreator = IIF(CurrentUser() IN ('btibbs', 'csarmiento'),
ProjectCreator ,CurrentUser)

.

References:
- Show all records in query if conditions is false
  - From: BLTibbs
- Re: Show all records in query if conditions is false
  - From: Duane Hookom
- Re: Show all records in query if conditions is false
  - From: BLTibbs
- Re: Show all records in query if conditions is false
  - From: John Spencer (MVP)

Prev by Date: Bit Data Type Issue
Next by Date: Re: how to create datediff function?
Previous by thread: Re: Show all records in query if conditions is false
Next by thread: RE: Access - ActiveX component
Index(es):
- Date
- Thread

Relevant Pages

Re: Only show rows where T1_F1 equals T2_F1 and T1_F2 equals T2_F2 and
... Nicholas Kormanik wrote: ... >What would be the SQL code for the following..... ... MVP ... Prev by Date: ...
(microsoft.public.access.queries)
Re: How to determine source of opened form
... Brendan Reynolds (MVP) ... I have a procedure that I wish to run depending on which form was used ... Prev by Date: ...
(microsoft.public.access.formscoding)
Re: fclose() ?
... Dave ... MVP VC++ FAQ: http://www.mvps.org/vcfaq ... Prev by Date: ...
(microsoft.public.vc.mfc)
Re: How to Replace Computer
... Mariëtte Knap - MVP ... Take part in SBS forum: ... Prev by Date: ...
(microsoft.public.windows.server.sbs)
Re: Microsoft Office Word index
... Herb Tyson MS MVP ... Please respond in the newsgroups so everyone can follow along. ... Prev by Date: ...
(microsoft.public.word.pagelayout)