Make Table Query Question

[Joe Blow]

Hello All:

Access 2003

I have a make table query and one of the field is a $$$ dollar amount.
I set the properties to "currency".

However, in the table, the field type is "Number".

Any ideas why this is happening?

-Joe

 

[Allen Browne]

You could try typecasting the field in your query.

For eample, if the design view shows the field like this:
Amount: [Quantity] * [UnitPrice]
try changing it to:
Amount: CCur(Nz([Quantity] * [UnitPrice],0))

In general, the better solution is to design the table the way you want it,
and then use an Append query to populate it, rather than a Make Table.