I have a table with some numeric fields with property double precision with 2 decimals. When using a table create query the property in the new table is double precision with automatic decimals. Now 3,40 becomes 3,40335162067604. How can I prevent this from happening?
Create table -> Numeric fields
- Thread starter ingrid
- Start date
R
Rich
Guest
Function Roundx(Value, Optional Precision As Variant) As Double
If IsNull(Value) Then Exit Function
If IsMissing(Precision) Then Precision = 2
Value = Fix(Value * 10 ^ Precision + 0.5 * Sgn(Value)) / 10 ^ Precision
Roundx = Value
End Function
If IsNull(Value) Then Exit Function
If IsMissing(Precision) Then Precision = 2
Value = Fix(Value * 10 ^ Precision + 0.5 * Sgn(Value)) / 10 ^ Precision
Roundx = Value
End Function
R
Rich
Guest
Having created the function you can then use it in your query
Total:Roundx([YourField])
Total:Roundx([YourField])
Similar threads
- Deleted Bruce 182381
- The Watercooler
