?
Solved

Problem with the column

Posted on 2014-03-07
2
Medium Priority
?
345 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 54

Accepted Solution

by:
Rgonzo1971 earned 390 total points
ID: 39911886
HI

pls try

select *
from tab2
where tab2.confirmed=Yes;

Open in new window

Regards
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 39912098
In Access, True is represented by a -1, not 1.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

589 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