yes/no data type

[Guest]

i have 2 queries and they both have yes/no fields in them. when i go to
datasheet view i can see the check mark in the field, but when i use a union
query to combine the two it gets rid of the check box and makes the field -1
and 0 is there a way to get this check box back?

 

[Rick B]

You can't display the checkbox in a query. The value stored in that field
is indeed a -1 or a 0.

If you want to see the checkboxes, use a report or a form.

 

[Guest]

how do i get the check box to appear on the report i see under format i can
change it to yes/no but i want to see a check box

 

[Rick B]

Use the checkbox tool in your toolbox and drag it to the report while in
design view. Then set the appropriate field value in the DATA tab.

 

[Rick B]

Oops. You don't "drag" the control to the report, you select it, then draw
a square on your report. I'm guessing you figured that out though.