Displaying Option Values in a Report as Text

G

Guest

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.
 
R

Rick Brandt

LinguaKids said:
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")
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top