Set a Field Value when using a make table Query

[JohnBoy]

Hi, I am pulling data fom SQL which makes a base table, when it runs I also add in 2 fields which are CreatedOn:"" and ModifiedOn:"", I then run another procedure using the newly made table to update these two fields from another table, My problem is that in the original table (lets call it base1) these two fields are set as text which really screws things up later when I try to use them,

The Make table query gets run once a week to capture any outstanding data etc so the table is over written then, I have tried setting the values in the property fields in the query but it dont seem to work, I want to avoid opening the table after each run and manually setting the field to DateTime.



Is there a way that I can set thsi so it does it each time I run the process.. ??

Cheers JB

[TheShabz]

look up the "ALTER TABLE" query. You will run that in between your queries.

[JohnBoy]

Hi... totaly outstanding and so simple, I cant believe I have been messing around with this for over a week and never even thought of that.... Many Many thanx once again

JB