Solved

Display certain text based on a checkbox

Posted on 2008-10-13
3
427 Views
Last Modified: 2013-11-28
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
Comment
Question by:NovatoNuevo
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 22708273
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question