Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When running a make table query I loss my formatting what can I do to ensure
my new table has the correct format
 
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.
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best third-party tool to repair OST files 3
Time format different in the query than the original table 4
Create Date Field from Text 2
Make Table Query - Formatting Percentages 3
IIf 1
Date format in a make table query 2
Format DATETIME to Date in query on linked table 4
Make table query: [Enter 1] AS Test 1

Back
Top