Change the 'Value' (number) to its labeled value in Access.

[Guest]

I'm trying to create a report in Access that will be grouped on an
'OptionGroup' field. Would like to find a way to reveal the corresponding
label to the option group number, in my report.

 

[fredg]

I'm trying to create a report in Access that will be grouped on an
'OptionGroup' field. Would like to find a way to reveal the corresponding
label to the option group number, in my report.

For just a few options?
Use an unbound control.
=IIf([OptionName] = 1,"LabelText1",IIf([OptionName] =
2,"LabelText2","LabelText3"))

For many more options, you could also use the Choose function in the
control source, or Select Case or If .. Then .. else .. End If in a
VBA function.
= FunctionName([OptionGroupName])

 

[Guest]

One way is to create reference table with the numbers and labels and then
join it in your query.

 

[Guest]

Thank you for the advice. I'll give it a try.

Bill

I'm trying to create a report in Access that will be grouped on an
'OptionGroup' field. Would like to find a way to reveal the corresponding
label to the option group number, in my report.

For just a few options?
Use an unbound control.
=IIf([OptionName] = 1,"LabelText1",IIf([OptionName] =
2,"LabelText2","LabelText3"))

For many more options, you could also use the Choose function in the
control source, or Select Case or If .. Then .. else .. End If in a
VBA function.
= FunctionName([OptionGroupName])

 

[Guest]

Thanks for the suggestion. I'll try a reference table.

Bill