Display certain text based on a checkbox
Posted on 2008-10-13
I have a query that pulls information from a table. In the table there are checkboxes. I want to produce a report based of the query which displays the different fields from the query. I also wanted to have the fields that are generated from a checkbox to be displayed in the report, but I wanted to have the field checkbox to display a text of my choice on the report. For example, if I have a table that has the fields for first name, last name and a checkbox that asks the user if he/she is married or not. In the report I want to display the first name , the last name and a text that says 'Married' if the users check my checkbox. Any help would be greatly appreciated.