Currency Value in Create Table Query

[Guest]

I want to create a table that will be used for a mail-merge with word. When
I create the table, I want to set the propoerties of the fields to Date/time
and currency where appropriate. When I try to set the Field Properties in
the Query, it doesn't work. Thanks in advance.

 

[Allen Browne]

To export to Word with the formatting, use calculated fields in your query,
e.g.:
Format([MyField], "Currency")
and
Format([MyDate], "Short Date")
You can tnen use the query as the source for the mail merge.

If you do want to make a table and define the data types, the simplest
solution is to build the table the way you want it, and then populate it
with an Append query. That gives you much more control over the process than
a MakeTable query does.

The other alternative if you want to continue with the MakeTable is to
typecast your fields in the query:
CCur(Nz([MyField],0))
and:
CVDate([MyDate])