Make up table Query

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

I have created a make-table query from a table that has
Yes/No field properties. When I go in to my new table,
the Yes/No field has changed to 0 or -1. How do I fix
this??? Thanks!
 
I have created a make-table query from a table that has
Yes/No field properties. When I go in to my new table,
the Yes/No field has changed to 0 or -1. How do I fix
this??? Thanks!
Click to expand...

Yes *IS* stored as -1, No as 0. That's the definition of a yes/no
field.

The solution is a) not to use table datasheets for data presentation;
use a Form instead, and set the format of the field; and b) to the
extent possible avoid using MakeTable queries AT ALL, they are very
rarely truly necessary. You can just use a Query as the recordsource
for a form or report (again, with appropriate formats for the fields).
 
Back
Top