Make table field format

[stephenk1973]

When using a Make table query i would like to add a field with no/null value but of date format.
Since there is no value it is crrently picking up the default field type text(255)

SELECT blah, blah2, Null AS [IN_DATE] INTO tblTemp
FROM TABLE_BLAH

Any ideas how to do this.

Any help appreciated.

Thanks

Stephen

 

[PHV]

You may try this two steps procedure:
1)
SELECT blah, blah2, Date AS [IN_DATE] INTO tblTemp
FROM TABLE_BLAH
2)
UPDATE tblTemp SET IN_DATE = Null


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886