Data Truncation (without Rounding) in VBA Access
Use the below function to truncate data in VBA Access
Function Trunc(number1 As Double, DecPlace As Integer) As Double Trunc = Fix(number1 * 10 ^ DecPlace) / 10 ^ DecPlace End Function
Customizable Disclaimer Section: Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
