P
Patrick Briggs
Earlier today I looked into adding a text column and a date column to an
existing table. I got it to work. I created a query in SQL and put the
following in it:
ALTER TABLE date_time_exper_tbl
ADD COLUMN [Payment Date Revised] DATETIME
for the text field:
ALTER TABLE [date_time_exper_tbl]
ADD COLUMN [Name of Lost Cause]TEXT (40)
My question now is, is there more detailed help for the Alter Table
Statement available somewhere? I'd like to see what the syntax should be for
other data types and how to set other Access properties (if possible) for a
given column-to-be-added.
Regards,
Patrick
existing table. I got it to work. I created a query in SQL and put the
following in it:
ALTER TABLE date_time_exper_tbl
ADD COLUMN [Payment Date Revised] DATETIME
for the text field:
ALTER TABLE [date_time_exper_tbl]
ADD COLUMN [Name of Lost Cause]TEXT (40)
My question now is, is there more detailed help for the Alter Table
Statement available somewhere? I'd like to see what the syntax should be for
other data types and how to set other Access properties (if possible) for a
given column-to-be-added.
Regards,
Patrick