• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

Display certain text based on a checkbox

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.
0
NovatoNuevo
Asked:
NovatoNuevo
1 Solution
 
Rey Obrero (Capricorn1)Commented:
create a query and make it te record source of the report

select first name, last name,iif([checkboxName]=-1,"Married","Single") as Status
from TableX
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now