make-table query

  • Thread starter Thread starter james
  • Start date Start date
J

james

If you have a make-table query but are setting it so that
it also adds a few more fields then that of the source,
how do you set it so that when the table is made, it has
a specific 'data type'
 
Dear James:

I believe most experienced developers avoid using Make Table queries
because there is little or no control over the datatypes used.
Instead, you can create a table in the ordinary way, specifying the
columns and their datatypes unambiguously, then append the rows to it
instead. This requires only a small adjustment to the existing Make
Table query, and gives superior results.

You will probably want to clear the table of rows each time you do
this, using a Delete query as well.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top