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)
 
Back
Top