AlexF777
asked on
Manipulating Yes/No field within VB, how should I construct my Insert, Select, etc.
when i look at this field in Access, it either shows 0 or -1 ( for any other value other than 0 )
Thanks in advance
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> 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