format field in make table query

[sierralightfoot]

Even though I have formated the field (currency) in the query, the format
does not come through to the table.

 

[Ken Sheridan]

Formatting only affects the appearance of the original data, not its data
type. To make the column in the new table currency data type use the CCur
function to return the values as currency data type. In query design view,
in place of the field name out something like this:

MyCurrencyField: CCur(Nz([MyField],0))

This should insert the values of MyField as currency data in the new table
in a column named MyCurrencyField, converting any Nulls to zeros (you can of
course use whatever name you like for the new column).

Ken Sheridan
Stafford, England

 

[Dale Fye]

The other way to address this is to only make the table once, then change the
data type of the field in the table. Then, in the future, insert into that
table and delete from it, rather than creating it and dropping it on the fly.

Another advantage of this is that if you create a report or query that uses
that table, it will always be there.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.