Checkboxes becoming -1 and 0 in Union Query

[Bill Bisco]

Dear all,

After putting in fields there were checkboxes into a Union Query, they now show up as -1s and 0s. Is a -1 a blank, and a 0 checked?

Thanks,

Bill

 

[pr2-eugin]

The other way around.. -1 is Checked and 0 is not.