Update query that changes the format of a field to currency

C

ChuckW

Hi,

I want to run a query that will change the format of a field, current as
general number, to currency. This is going to be a daily thing so I want to
automate this rather than manuallly changing it each time. I assume this
would be an update query. Can someone tell me how to create this?

Thanks,
 
M

Marshall Barton

ChuckW said:
I want to run a query that will change the format of a field, current as
general number, to currency. This is going to be a daily thing so I want to
automate this rather than manuallly changing it each time. I assume this
would be an update query. Can someone tell me how to create this?
Click to expand...


Formatting is not appropriate in tables. It's just an
extraneous property that has no significant benefit beyond
debugging your forms and VBA procedures.

Formatting in a query is only marginally more useful. The
case where this is essential is when you are exporting data
to another a file or another program. In this situation,
you should use the Format function to do it, not messing
with the original data table. E,g,
Format(somefield, "Currency")

If you are presenting the data for users to enter/view/edit
data values, then you should be using a form. Form text
boxes can be formatted just by setting their format
property.
 
Top