I have a word merge, trying to merge from my field 'GENDER' which
holds the either Male or Female.  In the word document, I have to ask
the question twice.  I have an M  and an  F and want an X to show up
next to the proper letter.
If Male then X otherwise blank.  M
If Female then X otherwise blank F
I want the X to go in front of the letter of which ever the gender is
and the other to be blank.

In my query I have two fields:
FEMALE: IIf([Gender]=[FEMALE],"X","")
MALE: IIf([Gender]=[FEMALE],"","X")
When I close the design view, this message comes up.
Circular reference caused by alias 'FEMALE' in query definition's
SELECT list.

What am I doing wrong and how can I fix it to ask the question twice?