<div>
Hi Jim,<br />
<br />
&gt;&nbsp;One problem with Access, as you have already discovered, is that instead of the 1 <br />
&gt;&nbsp;for True that SQL Server (and darn near every other db) uses Access uses -1. &nbsp;<br />
<br />
Excel uses 1 for True as well, which occasionally causes head-scratching when you push-pull data between Excel<br />
and Access :)<br />
<br />
<br />
Regards,<br />
<br />
Patrick
</div>


<div>
<div class="content wysiwyg-content">
when i look at this field in Access, it either shows 0 or -1 ( for any other value other than 0 )<br />
<br />
Thanks in advance<br />

</div>
</div>


when i look at this field in Access, it either shows 0 or -1 ( for any other value other than 0 )

Thanks in advance


Hi Jim,

&gt; One problem with Access, as you have already discovered, is that instead of the 1 
&gt; 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

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

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.