Union Query

[Guest]

I have some fields in a Data Base designed as Yes/No fields. I have created
a Union Query on certain fields and based a Select query on the Union Query.
When I bring the field into a report it show the Yes/No result as 0 or -1.
Is there a way that the Yes/No result can be displayed in the report as it
appears on the Form ie: a Check Box with a tick for yes and Blank for No.

Thanks for any help

 

[John W. Vinson]

I have some fields in a Data Base designed as Yes/No fields. I have created
a Union Query on certain fields and based a Select query on the Union Query.
When I bring the field into a report it show the Yes/No result as 0 or -1.
Is there a way that the Yes/No result can be displayed in the report as it
appears on the Form ie: a Check Box with a tick for yes and Blank for No.

Doesn't matter whether it's a UNION query or not: Yes is always stored as -1,
No as 0.

Put a Checkbox control on the form or report with this field as its control
source. Data display and data storage are *separate issues* - no table has
ever contained a checkbox!

John W. Vinson [MVP]

 

[tshillam]

I have some fields in a Data Base designed as Yes/No fields. I have created
a Union Query on certain fields and based a Select query on the Union Query.
When I bring the field into a report it show the Yes/No result as 0 or -1.
Is there a way that the Yes/No result can be displayed in the report as it
appears on the Form ie: a Check Box with a tick for yes and Blank for No.

Thanks for any help

Create a subquery of the UNION query, then format the field as Yes/No--
that's an option.