yes/no field format

  • Thread starter Thread starter MSD
  • Start date Start date
M

MSD

Hi,

I have two queries containing yes/no fields, which display in a check box
format. This is how I want them. When I run a union query joining these two
queries, the yes/no field is displayed as 0 or -1. This messses up my
multi-select list box display.

Does anyone know why the UNION query won't keep the check box format for a
yes/no field?

Thanks very much,

Emma
 
A union query doesn't allow updates. You should display the query in either
a form or a report where you can use a check box to display the value.
 
Back
Top