[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1003
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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