Reformat query result values for report?

[ad2]

Hi,

In my subject table the values for male=1, female=2.

In either the query or repost design, how can I display the numbers as their text equivalent so that the user can have a better understanding of the value?

Thanks,
Ad2

 

[lespaul]

SELECT IIF(Sex = 1, "Male", "Female") As SexType FROM TableName

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[PHV]

You may also consider the Choose function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886