Adding a date field with code

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I am trying to add a field using code, it is a date field
but I just cannot get this to work, any suggestions

dbs.Execute "ALTER TABLE orders ADD COLUMN
emaildate date/time"

Nigel
 
The datatype is "DATE" and not "DATE/TIME" Therefore:

dbs.Execute "ALTER TABLE orders ADD COLUMN emaildate date"

should work.
 
Back
Top