Replace the number with value on a report for Gender

[Khalil Handal]

Hi to all
In a table design I have Gender field with Data Type: Number where 1 is for Male and 2 is for Female.
On the form I have an Option Group for Gender, the user selects either button.
I created a report and on the report the value for gender field is shown as either"1" or "2".

Is it possible on the report to replace the 1 for Male and the 2 for Female?



Thank you
Khalil

[ArviLaanemets]

Options

1. Edit the source query of report like

SELECT ..., Iif(Gender=1,"Male","Female") ...

2. Have a table like Genders: Gender, GenderTxt
with values
Gender GenderTxt
1 Male
2 Female
Edit the source query of report like

SELECT yt.Field1, ..., g.GenderTxt, yt.Fieldn FROM YourTable yt INNER JOIN Genders g ON g.Gender = yt.Gender

And I'd advice to use combo box for selecting the gender in your form, WITH ControlSource property as Gender (The Gender field in your original table). In case you don't have a table for genders, set the RowSourceType property for combo as "Value List", and RowSource property as "1, Male, 2, Female". In case you have a table for genders, set the RowSourceType property for combo as "Table/Query", and RowSource property as "SELECT Gender, GenderTxt FROM Genders ORDER BY ...". Set ColumnCount property for combo to 2, BoundColumn property to 1, and ColumnWidths property like "0,2.5"
Now whenever user clicks on the combo, user can select between "Male" and "Female", and depending on made selection, the value of combo will be either 1 or 2.

[jojowhite]

as advised, use query as recordsource of your report.

you can also use Choose() function on your Query:

Select field1name, field2name, Choose([gender], "Male", "Female") As Sex From yourTableName;

[Khalil Handal]

Hi,
Got it working
Thank you both