Query

[Robert Smith]

I have a query where the field is male/female. male = 1 female =2. In the
results, I want to display the term male instead of 1 and female instead of
2. Is there a way to do this.

 

[Duane Hookom]

You can create a column in your query with the expression:
MF: Choose([Male/Female], "Male", "Female")