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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Mismatch in Excel 2010 4
bitwise operator in SQL 3
Add autonumber to a large table? 0
Access Dcount (multiple criteria) 3
Parsing a table 1
"Read Only" Query 0
DLookup and Nz 0
Need to add more fields but schema is expanded to its maximum? 1

Back
Top