Show all records in query if conditions is false

[Guest]

I have a query that I want to show the records only created by the person who
is currently logged in. However, I have two specific log-in names that I
want to allow to view all records in the query without restriction. Here is
my IIF:

iif(currentuser()<>"btibbs" or "csarmiento",currentuser())

So if your name is not btibbs or csarmiento, you only see records that you
created, but I want ALL to show if btibbs or csarmiento are logged in.

Thanks

 

[Duane Hookom]

IIf() takes three arguements and you have provided two. Also, you must use
iif(currentuser()<>"btibbs" or
currentuser()<>"csarmiento",currentuser(),[UserFieldName])
or
iif(currentuser() IN ("btibbs","csarmiento"),currentuser(),[UserFieldName])

 

[Guest]

The name of the field that I store the user name in when the record is
created is called [projectcreator]. Below is the equation that you showed me:

iif(currentuser()<>"btibbs" Or
currentuser()<>"csarmiento",currentuser(),[projectcreator])

But logged in as btibbs, I still just get the records for btibbs. If I am
btibbs or csarmiento, I want all of the records, otherwise, I just want the
records of the person logged in. What am I missing?

Thanks for your help! - Brian

IIf() takes three arguements and you have provided two. Also, you must use
iif(currentuser()<>"btibbs" or
currentuser()<>"csarmiento",currentuser(),[UserFieldName])
or
iif(currentuser() IN ("btibbs","csarmiento"),currentuser(),[UserFieldName])
--
Duane Hookom
MS Access MVP

I have a query that I want to show the records only created by the person
who
is currently logged in. However, I have two specific log-in names that I
want to allow to view all records in the query without restriction. Here
is
my IIF:

iif(currentuser()<>"btibbs" or "csarmiento",currentuser())

So if your name is not btibbs or csarmiento, you only see records that you
created, but I want ALL to show if btibbs or csarmiento are logged in.

Thanks

 

[John Spencer (MVP)]

Pardon me for butting in.

Field: ProjectCreator
Criteria: LIKE IIF(CurrentUser() in ("btibbs","csarmiento"),"*",CurrentUser)

The name of the field that I store the user name in when the record is
created is called [projectcreator]. Below is the equation that you showed me:

iif(currentuser()<>"btibbs" Or
currentuser()<>"csarmiento",currentuser(),[projectcreator])

But logged in as btibbs, I still just get the records for btibbs. If I am
btibbs or csarmiento, I want all of the records, otherwise, I just want the
records of the person logged in. What am I missing?

Thanks for your help! - Brian

IIf() takes three arguements and you have provided two. Also, you must use
iif(currentuser()<>"btibbs" or
currentuser()<>"csarmiento",currentuser(),[UserFieldName])
or
iif(currentuser() IN ("btibbs","csarmiento"),currentuser(),[UserFieldName])
--
Duane Hookom
MS Access MVP

I have a query that I want to show the records only created by the person
who
is currently logged in. However, I have two specific log-in names that I
want to allow to view all records in the query without restriction. Here
is
my IIF:

iif(currentuser()<>"btibbs" or "csarmiento",currentuser())

So if your name is not btibbs or csarmiento, you only see records that you
created, but I want ALL to show if btibbs or csarmiento are logged in.

Thanks

 

[Guest]

Thanks John Spenser!! That works! Butt in any time...

Pardon me for butting in.

Field: ProjectCreator
Criteria: LIKE IIF(CurrentUser() in ("btibbs","csarmiento"),"*",CurrentUser)

The name of the field that I store the user name in when the record is
created is called [projectcreator]. Below is the equation that you showed me:

iif(currentuser()<>"btibbs" Or
currentuser()<>"csarmiento",currentuser(),[projectcreator])

But logged in as btibbs, I still just get the records for btibbs. If I am
btibbs or csarmiento, I want all of the records, otherwise, I just want the
records of the person logged in. What am I missing?

Thanks for your help! - Brian

IIf() takes three arguements and you have provided two. Also, you must use
iif(currentuser()<>"btibbs" or
currentuser()<>"csarmiento",currentuser(),[UserFieldName])
or
iif(currentuser() IN ("btibbs","csarmiento"),currentuser(),[UserFieldName])
--
Duane Hookom
MS Access MVP


I have a query that I want to show the records only created by the person
who
is currently logged in. However, I have two specific log-in names that I
want to allow to view all records in the query without restriction. Here
is
my IIF:

iif(currentuser()<>"btibbs" or "csarmiento",currentuser())

So if your name is not btibbs or csarmiento, you only see records that you
created, but I want ALL to show if btibbs or csarmiento are logged in.

Thanks

 

[peregenem]

Field: ProjectCreator
Criteria: LIKE IIF(CurrentUser() in ("btibbs","csarmiento"),"*",CurrentUser)

Alternatively (in SQL code):

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