How do I specify a field type in Make-Table query? 1

[UongSaki]

Is there a way to tell Access to create a table with field type using Make-table query? I want to create a text field type where Access currently creates a number's.

Thanks,

UongSaki

 

[PHV]

Have you tried to use the Format or CStr function ?

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

 

[UongSaki]

PHV, Thank you. The CStr function works perfectly.

UongSaki