Formatting

U

UG

When running a make table query I loss my formatting what can I do to ensure
my new table has the correct format
 
O

Ofer Cohen

Create a table with the right formatting, and then run an Append query
instead of a make table query.
You'll need to delete the data first, and then append the new data.

That way you know exactly the right structure of the table, and you can
create Keys.
 
J

John Vinson

When running a make table query I loss my formatting what can I do to ensure
my new table has the correct format
Click to expand...

MakeTable queries are in practice very rarely needed; and if you're
using table datasheet view for viewing or printing, bear in mind that
this is NOT what Tables are designed for.

Why do you feel that a MakeTable is needed? Might it not be better to
create a Form (for onscreen viewing) or Report (for printing), with
the formatting you want, and base it on a Select Query returning the
same data that your MakeTable query uses?

John W. Vinson[MVP]
 
Top