I've had this problem with both Access XP and now Access 2003. I have
a table with yes/no fields, properly formatted. I have a "make table"
query based on this, but when I run the query, the resulting table
loses the "yes/no" format - these fields appear as -1 or 0.
Does anybody know the solution?

You need to manually change the Lookup setting for the field to Check Box
(do in table design view). The default setting for the field is used when
you use a make-table query, and a Yes is stored as -1 and a No as 0 in an
ACCESS database.

--

Ken Snell
<MS ACCESS MVP>


"Paul Danaher" <paul.danaher (AT) watwinc (DOT) com> wrote

Ken Snell wrote:
confused by that, so I need to create a lookup form.