Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1000
  • Last Modified:

Truncate values in Access

How can I trucate figures when creating calculations in a query, (the function TRUNC is not available in access).
0
ESmith
Asked:
ESmith
1 Solution
 
almond_ukCommented:
Have you tried the FIX function?
0
 
AlexJ030200Commented:
Hi almond_uk ,

Do you need to truncate them? If you only need to display trucated values an alternative solution is to play with the format of forms and reports and keep the most exact value internally.

Hope this helps.
0
 
ESmithAuthor Commented:
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)
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now