MakeTable query with NEW blank field

[jw5107]

I am generating a make table query. I want to add new fields that will be updated later on via an update query. The problem is when I put Fleet: Null as the new blank field in the make table query - upon query being ran I get the field fleet to be binary data type.
How can I set this to text or number??

Any suggestions??
jw

 

[hneal98]

instead of putting a null, put a blank ''.

 

[PHV]

Put an empty string for text and 0 for number.

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