Improve company productivity with a Business Account.Sign Up

x
?
Solved

Display certain text based on a checkbox

Posted on 2008-10-13
3
Medium Priority
?
455 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
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Implementing simple internal controls in the Microsoft Access application.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

588 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