Need query to show currency to 4 decimals

[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.

 

[Joseph Meehan]

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.

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

 

[JK]

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