Prev: Numeric or Alpha
Next: Follow-up to my 5/6 Post
From: KenSheridan via AccessMonster.com on 12 May 2010 07:31
It sounds like your check boxes are options in an option group bound to a
numeric column in the form's underlying table. If so you should create a new
table Genders with two columns GenderID (integer number) and Gender (text).
Index both columns uniquely. In the first column enter the number which
corresponds to the values in your existing table assigned by the option group
in your form when you select an option, and in the second column enter the
corresponding text value, e.g.

1 Male
2 Female
3 Trans
<and so on>

Create a relationship between the new Genders table and the existing table on
the GenderID column and the relevant gender column in your existing table.
Enforce referential integrity.

Base your report on a query which joins the two tables on the two columns by
which the tables are related (Access will probably create the join
automatically when you add the tables in query design view). Include the
Gender column from the genders table in the query's output and bind a text
box to this in your report. You'll then see the text value which corresponds
to the numeric value in your existing table.

Ken Sheridan
Stafford, England

dave117 wrote:
>Hello,
>I am new to access 2007, and need to do the following
>I have created a form and in there is a selection of check boxes.
>Simply put for gender if they are male check here felame check here trans-
>here etc.
>I am trying to generate a report that lists by the id number as a text string
>but I am getting out the option field output number 1, 2, 3, 4 etc
>How do I get this to be the text value, not the field output number
>Please keep it simple as I am new!!
>thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1

 | 
Pages: 1
Prev: Numeric or Alpha
Next: Follow-up to my 5/6 Post