CDec() Formatting

[jo15765]

I am trying to convert a field in an access query to show 6 decimal places. This is what I have currently and I get an error of 'The expression you entered has a function containing the wrong number of arguments'

CDec([field])

[JoeM]

You cannot use CDec in a query, only in VBA. See: http://support.microsoft.com/kb/225931/en-us

You should just be able to format the result to show 6 decimal places. Just right-click on the field name in the Query Builder to bring up the Properties of the field, and enter 6 in the Decimal Places property.