SQL add date column, change format, and change date

[Jrod2541]

So I'm trying to make a query that adds a column to my table named "Table1". That column's name id "Date". (I'm not sure the syntax to add a DATE/TIME datatype)

ALTER TABLE Table1 
ADD COLUMN Date DATE;

After that I'd like to also like to change the format to "yymmdd",

Format(Date, "yymmdd")

, and change the date (or make it default) to what ever the date is.

NOW()

Is there any way I can do this in access or is it impossible?

[twinnyfo]

Jarod,

Is there a reason you must do this via VBA, rather than just adding the field in design view? I believe it is possible to do what you want in VBA, although I would have to do some learning myself.....

[us hosting]

While adding the column, specify the format.

[Jerry Maiapu]

Maybe explaining what you what to achieve can enlighten members to resolve the issue with more amicable approach because what you are mentioning is bit strange in db design.

Usually you will be trapped in this sort of situation when your table relationship are not defined properly.

Thanks!