Create a blank double column in make table query

[dassuz]

Hi Can someone please advise me how I can make a blank numeric double column in a make table query.

Thanks in Advance

 

[Ranman256]

you must create a number:
MyField: CDbl(0)


then set it to null in an update query. You cannot make a null field and get your type.
so 2 queries: make , then update.