I can have it on same table.
So what I initially tried (in an Access query - it's faster ) was:
SELECT Gender FROM Table Where IIF(Gender, "Dear Mr.", "Dear Mrs.")

It just gives me the field Gender without any change.
The computer is right of course. But there must be something narrowing my mind that's not allowing me to breakthrough.