Yes/No field variables on report from UNION query

[intern42]

I have a Yes/no field called "required" that comes up as a checked or unchecked box when I reference it in a report.

For my latest report, I had to build a query that combined 3 different SELECT statements with the UNION command.

In the report I generated from this query, the required field comes up as either a 0 or a -1 instead of the checked/unchecked box.

The ONLY diffenence (that I can see) is that this report is built off of a UNION query.

Any ideas why I'm getting zeros and -1's instead of the checked/unchecked boxes?

 

[jrbarnett]

Look in the report design and change the properties of the field it is displayed in.

John

 

[intern42]

Thanks.

That helped.

I forgot to drag the checkbox item onto the form.

Gotta love Mondays.