Hold formatting with Make Table Query

[nc]

I have developed a database for use in the Eurozone (I operate in sterling).
I have formatted a couple of fields in a query to show a date field as
'medium date' and a currency field as 'Euro'. This works fine when used as a
select query but when I try to convert it to a Make Table query I lose the
formatting. How can I get round this?

 

[Douglas J. Steele]

Recognize that formatting only impacts how values are presented to the user,
not their actual values.

You could use DAO to modify the Format property of the specific fields in
the table you just created, or you could base a query on the table you just
created and use that query wherever you would otherwise have used the table,
or you could insert into an existing table rather than creating a new one.

However, in my opinion, it's extremely rare to have MakeTable queries in a
production application. Is there a reason why you're doing this?

 

[nc]

Thanks Douglas.
By exporting the Query instead of the Table I can retain the formatting in
Excel. I preferred having a Table created in the database so that there
would be a record of the various payments made.