[AccessD] Option Group on Report

Set the (I think it's called recordsource or something like that) of the
text field on the report to:

=iif([somefield]=1,"Go",iif([somefield]=2,"No Go","N/A"))

There is the switch statement that might do what you want and there is
another statement that I can't remember what it is called right now that may
work.  I do not have access to my machine with Access on it at the moment.

Bobby 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Monday, February 05, 2007 12:39 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Option Group on Report

I have an option group on a form. How do I get the related word from the
selected option to show on a report?

 

Choices for Option group

1- Go

2 - No Go

3 - N/A

 

The report needs to show the words "Go", 'No Go" or "N/A" not the number
(1, 2, or 3).

 

Virginia