August 16, 200916 yr Newbies I have a table with a field called "sex" for the user to enter "M" for male and "F" for female. I have a healthcare report that requires that I display a box for male and a box for female. I am looking for a way to put a field on the report for "Male" and a field for "Female" and I want the "Male" field to display "X" if the table field sex is "M" and blank if the sex field is "F". I want the same conditional formatting for the "Female" field on the report to display "X" if the table field "sex" has "F" and blank if the sex field has "M".
Create an account or sign in to comment