Add Column in make table query

  • Thread starter Thread starter Michael Noblet
  • Start date Start date
M

Michael Noblet

I have a make table query that I have created and I would
like to be able at the time of creation to add a column
for check boxes to the table. I assume I just need to add
to the SQL statement but I am not sure of the syntax. Any
help would be appreciated.

Mike
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can't designate the data type of a "new" column in the make-table
query, 'cuz the make-table query uses the data types of the source table
while creating the target table. Though you can indicate a new column
in the SQL of the make-table query you can't designate the data type in
the SQL statement. You can only designate the data type in a DDL (Data
Definition Language) statement: ALTER TABLE; CREATE TABLE.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQQG+u4echKqOuFEgEQIySwCeLNX18LBiLO4wYqoYqTUGnQ54+gEAn19f
MOQwUTxoHjXRfW1bMweooNDo
=aT0p
-----END PGP SIGNATURE-----
 
Back
Top