Son/Daughter Report

[bigbadbess24]

I am creating a letter in a report for parents. In the report I want it to figure out whether it should say son or daughter. I do have a field for sex (M/F). Is there a way to tell the report to say son or daughter base on the sex field?

 

[bigbadbess24]

Sorry I wrote this in the wrong place, I put it in Report Forum. But if you can help me out that would still be great.

 

[Pat Hartman]

You can use the IIf() function in your query.
Select ...., IIf(SexCode = "F", "Female", "Male"), As SexName, ....
From YourTable;

Use the query as the RecordSource for your report.

 

[Pat Hartman]

Please don't start multiple threads on the same topic.