Make table query

  • Thread starter Thread starter Phil Hunt
  • Start date Start date
P

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.
 
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.
 
Thanks. That's what I thought.

Douglas J. Steele said:
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.
Click to expand...
 
Back
Top