We help IT Professionals succeed at work.

Manipulating Yes/No field within VB, how should I construct my Insert, Select, etc.

AlexF777
AlexF777 asked
on
Medium Priority
209 Views
Last Modified: 2010-04-07
when i look at this field in Access, it either shows 0 or -1 ( for any other value other than 0 )

Thanks in advance
Comment
Watch Question

SQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Either True or false, -1 or 0, your call.

One problem with Access, as you have already discovered, is that instead of the 1 for True that SQL Server (and darn near every other db) uses Access uses -1.  

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Top Expert 2010

Commented:
Hi Jim,

> One problem with Access, as you have already discovered, is that instead of the 1
> for True that SQL Server (and darn near every other db) uses Access uses -1.  

Excel uses 1 for True as well, which occasionally causes head-scratching when you push-pull data between Excel
and Access :)


Regards,

Patrick
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.