Displaying Option Values in a Report as Text

[LinguaKids]

I have a form with an option group that has three options. The results are
stored in a table as either 1, 2 or 3. On my reports, I would like to
display text instead of the actual values to make it meaningful. I'm sure
this is simple, but I haven't been able to find the answer I'm looking for.

 

[Rick Brandt]

I have a form with an option group that has three options. The
results are stored in a table as either 1, 2 or 3. On my reports, I
would like to display text instead of the actual values to make it
meaningful. I'm sure this is simple, but I haven't been able to
find the answer I'm looking for.

Check help for the Choose() function.

=Choose([YourField], "Text1", "Test2", "Text3")

 

[Allen Browne]

See help on:
Choose()

 

[LinguaKids]

Thanks - that was exactly what I needed.

See help on:
Choose()

 

[malacqua]

I am having a hard time trying to send a question. This is the only way I
can get one off to you. Please send me a reply to the email address above.

I am using Access 2000
In a report that shows me what is owe me in 7 days, 14 days, 21 days and so
on. It rounds the day from the day I am asking the report, tomorrow it will
show different amounts. How can I get it to stabilize to a certain day of
the week to start pulling from?'

email me back at (e-mail address removed)

thank you