Solved

Problem with the column

Posted on 2014-03-07
2
333 Views
Last Modified: 2014-03-07
Hi,
"confirmed" is one Yes/No column on the table. within the table, I see there is only one record with such column checked.

But do I also get that record by this query

select *
from tab2
where confirmed<>1

as "Checked" should mean it equals 1, right?
0
Comment
Question by:HuaMinChen
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 130 total points
ID: 39911886
HI

pls try

select *
from tab2
where tab2.confirmed=Yes;

Open in new window

Regards
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39912098
In Access, True is represented by a -1, not 1.
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

Creating and Managing Databases with phpMyAdmin in cPanel.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

808 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