A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Output field as a text



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 12:31 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Output field as a text

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/For...arted/201005/1

  #2  
Old May 12th, 2010, 01:59 PM posted to microsoft.public.access.gettingstarted
dave117
external usenet poster
 
Posts: 1
Default Output field as a text

KenSheridan via AccessMonster.com wrote on 05/12/2010 07:31 ET :
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/For...arted/201005/1

Thank you sir
I will try it
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.