<div>
thank u Both a lot. I am clear now.<br />
<br />
regards<br />
Laks
</div>


thank u Both a lot. I am clear now.

regards
Laks

<div>
Cheers mate.<br />
<br />
Good luck with your project..<br />
<br />
Dave
</div>


Cheers mate.

Good luck with your project..

Dave

<div>
Glad to help, Laks. Cheers for the nod.<br />
<br />
s46.
</div>


Glad to help, Laks. Cheers for the nod.

s46.

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I have a field in a table with &quot;Yes/No&quot; data type. While using the simple query for that table the result of the &quot;Yes/No&quot; field is working Ok. But when i combine another table using the &quot;UNION&quot; operator, the value displays for the &quot;Yes/No&quot; field is 0 for False and -1 for True. Why? Please..<br />
<br />
Thanx in advance<br />
<br />
Laks.R
</div>
</div>


Hi Experts

I have a field in a table with "Yes/No" data type. While using the simple query for that table the result of the "Yes/No" field is working Ok. But when i combine another table using the "UNION" operator, the value displays for the "Yes/No" field is 0 for False and -1 for True. Why? Please..

Thanx in advance

Laks.R

Reg. Yes/No field value display in UNION query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.