Formatting Table from Make Table Query

[HD20]

I have a Make Table query where one of the fields is formatted as currency. However, when it creates the table, the formatting reverts back to general number. Does anyone know how to fix this? Thanks.

 

[llkhoutx]

Currency is not a data type, but a data format.

 

[HD20]

I am sorry, I don't understand your reply. How would I get the table to produce currency?

 

[llkhoutx]

Access stores numbers; bytes, integers, long, etc.

Access displays numbers via formats; with 2 decimals, 9 decimals, currency with & without decimals, text, etc.

Displaying a number as currency is a method of displaying a number which is stored in a table/query or is calculated.

Data is not stored as currrency, it's stored as a number. You can't save a currency, you save a number.

A table will not produce currency! It stores numbers, text and all the other data types. Currency is not a data type. It's a data format.

Crystal clear?

 

[HD20]

Crystal, thanks!