Solved

Display certain text based on a checkbox

Posted on 2008-10-13
3
439 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

626 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