ESmith
asked on
Truncate values in Access
How can I trucate figures when creating calculations in a query, (the function TRUNC is not available in access).
Have you tried the FIX function?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, I can see the logic to your answer, but I wish it was as simple as adding a function (I have tried fix(), but in this case it would not have been appropriate)