Changing the format of a field

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have a field in a table that is set as being a general
format. I want to create a make table query and have the
field be changed to currency. I am then sticking my make
table query as part of a macro than runs about a dozen
other make table queries which are run every day. I
don't want to have to go into my newly created table and
change the format from general to currency. Is there a
way in a query to change the format from general to
currency. Or is there a way to change the format of a
field in my newly created make table without having to
manually do so every day?

Thanks,

Chuck
 
Dear Chuck:

Usually, it is best not to use a Make Table query. It gives you
little control over the data types of the columns.

Instead, create a table to receive the data. Instead of a Make Table
operation, clear the table with a DELETE query then use an Append
instead of Make Table. You'll be happier with the results.

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