Make Table Query Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Blow - 21 Jul 2007 05:19 GMT

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

Reply to this Message

Allen Browne - 21 Jul 2007 07:31 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello All:
>
[quoted text clipped - 8 lines]
>
> -Joe

Reply to this Message