Create new Yes/No field from query

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

I need to add a new Yes/No field from a query, i have this so far, but I
need the format to be True/False. How do I do that from a query?

ALTER TABLE MyTable ADD MyField bit default false
 
Access is really two pieces: 1) The JET database engine (for an mdb file);
2) The Access application interface.

Format is an "extended" property that JET supports but does not use. You
see the effect of Format only in the application interface.

So, why did I tell you all that? Access Data Definition Language (DDL)
queries support only the base JET engine attributes. There's no way to
specify the "extended" Format property. You can do it in code by messing
with the Field object in the TableDef (DAO) or the Column object in the
Table (ADO).

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 

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

How to query a field for Absolute Value in Access 2007 7
Split data in field on character return 0
sub query 3
counting yes/no fields 3
Counting up Yes/No fields in queries 3
crosstab query column heading 2
Subquery nested in Update query 1
adding yes/no field 2

Back
Top