Make Table Queries

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hello,

Is it possible to create a make table query and specify
the type and size of the fields in the created table? I
need to constantly run a make table query to update
information I use for reports, but I want my dates stored
in date fields and numbers in number fields. I can't set
the properties in the table itself, since it gets deleted
and re-created every time you run the query. I know I could
create the table and use an update query, but it is much
simpler to keep the make table query, and want to know if
it is possible to do this. Thanks

Tim
 
Tim said:
Hello,

Is it possible to create a make table query and specify
the type and size of the fields in the created table? I
need to constantly run a make table query to update
information I use for reports, but I want my dates stored
in date fields and numbers in number fields. I can't set
the properties in the table itself, since it gets deleted
and re-created every time you run the query. I know I could
create the table and use an update query, but it is much
simpler to keep the make table query, and want to know if
it is possible to do this. Thanks
Click to expand...

This is not possible in a MakeTable query. Why do you feel a MakeTable
query is easier than just using Delete and Append queries against a table
that you DON'T destroy each time?
 
Look into the CreateTableDef method in code or the Create
Table Statement using SQL directly both will allow u 2 set
the properties of each field...
 
Back
Top