Brilliant!

"Gary Walter" wrote in message
...
Hi TT,

just in case "TT" 'tt' (other post)

Another clever method Michel once demonstrated:

NewField: IIf(True,Null,#1/1/1900#)

-- you end up with date/time field, all nulls

-- works for text and number also
NewField: IIf(True,Null," ") --get type text(255), all null
NewField: IIf(True,Null,0) --get type Long, all null

-- or use Cxxx functions
NewField: IIf(True,Null,CCur(0)) --get type Currency, all
null
NewField: IIf(True,Null,CDbl(0)) --get type Double, all
null

So clever...and eliminate "binary type" bugaboo
when you use

NewField: Null

Please respond back if I have misunderstood.

Good luck,

Gary Walter


"TT" wrote in message
...
I am trying to create a new table using a make-table query
where one of the fields is formatted as a date but has no
data in it initially.