Make table query

[coryt]

Hi. I want to create a make table query where 2 of the 6 fields are set to data type number when the table is made. As it stands, the default data type is text. Is this possible???

Thanks in advance.

 

[dcx693]

Yes, search the forums for some examples, but you can use the type conversion formulas like Cint(), Cdate(), etc... in your SQL statement like SELECT CDate([field]) as Date, etc... INTO tablename etc....

 

[coryt]

worked perfect!!!! Thank you.

 

[dcx693]

Great. No prob. Now that I look at my make-shift example again, I wouldn't suggest naming any field "Date" since it's a word that is used in other contexts with Access.

 

[coryt]

ok, I didn't anyway. both of the fields I wanted to change were general numbers named Grade and Box Number... THanks again