Make Table Qry Changes field format

  • Thread starter Thread starter Chris Windsor
  • Start date Start date
C

Chris Windsor

What causes a make table query that is using another query for some of its
data to change the field format in the resulting table? I want the format
to be currency, but it ends up a decimal number with a LONG number of
decimal digits.
 
Chris

Is it necessary to "make" a new table every time? Or would it be sufficient
to load an existing table (append query)? If the latter, you could create
the destination table structure to be just what you want, rather than
relying on Access' attempt to figure out what data types are needed.

Good luck

Jeff Boyce
<Access MVP>

P.S. You could set up a second query to delete all records from that
destination table before running the "new" append.
 
Back
Top