Need query to show currency to 4 decimals

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I have a table that will store currency data to
four decimal places. But the table will only show
two decimal places unless you click on the specific
datam and then it will show four places.

I want a query based on this table to show all the
decimal places for the currency data.

Thanks in advance for any help here.
 
tom said:
I have a table that will store currency data to
four decimal places. But the table will only show
two decimal places unless you click on the specific
datam and then it will show four places.

I want a query based on this table to show all the
decimal places for the currency data.

Thanks in advance for any help here.
Click to expand...

Put it in design view and take a look at properties for that field. I
believe you can define the display there.
 
Tom,

If you are using Currency format, change it to Double and format it to 4
decimal points eg:
#,##0.0000;-#,##0.0000;0.0000

Regards/JK
 
Back
Top