Solved

Problem with the column

Posted on 2014-03-07
2
332 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 49

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 365 home questions 7 65
hit enter key to run macro 13 23
is Microsoft Access going to Die? 9 42
Coldusion - DATA insert syntax problem 12 24
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

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