Option Group

[ladybug via AccessMonster.com]

I have a query with a field from an option group. 1=Internal, 2=Client.
Now in my query how do I have it return the text Internal and Client instead
of 1 and 2. The field name is RequestedBy.
I think this should be fairly easy, but I have never used it before.

 

[Jeff Boyce]

Take a look at the IIF() function in Access HELP. You could add a new field
in your query and use something like (untested):

NewField: IIF([RequestedBy] = 1, "Internal", "Client")

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ladybug via AccessMonster.com]

That is almost perfect, but if it is not selected (0) I do not want Client
returned. I would just want it to be blank.

Take a look at the IIF() function in Access HELP. You could add a new field
in your query and use something like (untested):

NewField: IIF([RequestedBy] = 1, "Internal", "Client")

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a query with a field from an option group. 1=Internal, 2=Client.
Now in my query how do I have it return the text Internal and Client
instead
of 1 and 2. The field name is RequestedBy.
I think this should be fairly easy, but I have never used it before.

 

[fredg]

That is almost perfect, but if it is not selected (0) I do not want Client
returned. I would just want it to be blank.

Take a look at the IIF() function in Access HELP. You could add a new field
in your query and use something like (untested):

NewField: IIF([RequestedBy] = 1, "Internal", "Client")

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a query with a field from an option group. 1=Internal, 2=Client.
Now in my query how do I have it return the text Internal and Client
instead
of 1 and 2. The field name is RequestedBy.
I think this should be fairly easy, but I have never used it before.

NewField: IIF([RequestedBy] = 1, "Internal", IIf([RequestedBy] = 2,
"Client",""))

 

[ladybug via AccessMonster.com]

THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!

That is almost perfect, but if it is not selected (0) I do not want Client
returned. I would just want it to be blank.

[quoted text clipped - 14 lines]
NewField: IIF([RequestedBy] = 1, "Internal", IIf([RequestedBy] = 2,
"Client",""))