troubleshooting Question

How to display yes/no if value is -1 / 0

Avatar of smods
smods asked on
Microsoft Access
12 Comments1 Solution286 ViewsLast Modified:
Hi,

Following on from my previous question:  

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27047167.html

When the checkbox access stores a Yes as -1 or a No as 0

I need it to be displayed in a different form as either Yes or No

Is there some code to put on the checkboxes that would store it as Yes or No or do I use a query to convert the answer stored in the table to Yes or No?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros