I am downloading info from Monarch and then adding two columns with data definition queries. The first one was a breeze.

ALTER TABLE workingpra ADD COLUMN Remarks TEXT (255)

The second one is a pain. I can not get it to add a date/time field, formated to medium date.

Any solutions? Is it possible to do them both in the same query instead of two seperate?

RichB

You can use ALTER TABLE to add the two fields at the same time. Don't worry about the date display as you can change that in the form. Just set the date field on the forms format propery to the date style you want.

Why don't you post the DDL statement you're having trouble with rather than the one that works http://www.access-programmers.co.uk/ubb/smile.gif

Well I went with this:

ALTER TABLE workingpra ADD COLUMN Extension DATE

And it worked. I could not get them both on one data definition query though so I have two until it gets figured out.