Change Data Types in a Make Table Query

[nyneave]

Access 2003 - Is there any way to change the data type in a "Make Table Query"? I have tried doing a format on the date columns and this doesn't work. I know there are coding ways to do it, but I thought this would be a simple feature in a UI like Access.

Thank you,
Nyneave

[June7]

Not in the design grid. You can write CREATE TABLE sql statement in SQL View. Review http://www.w3schools.com/sql/sql_create_table.asp

The resulting query can be saved but won't open in Design view, only SQL View.