Make table query

[Phil Hunt]

Can you set the datatype within a make table query. I want to add a new
field which I want it to be yes/no but it comes out as number 0 in the
table schema. I like it to be yes/no.

 

[Douglas J. Steele]

Are you saying that the field that's created is a Numeric field, or that
it's a Yes/No field, but it displays a number, not the words Yes or No?

You have very little control over Make Table queries. That's why the
recommended approach is usually to create the table first, and then append
to it.

 

[Phil Hunt]

Thanks. That's what I thought.

Are you saying that the field that's created is a Numeric field, or that
it's a Yes/No field, but it displays a number, not the words Yes or No?

You have very little control over Make Table queries. That's why the
recommended approach is usually to create the table first, and then append
to it.