Solved

Truncate values in Access

Posted on 2000-05-17
3
991 Views
Last Modified: 2010-05-18
How can I trucate figures when creating calculations in a query, (the function TRUNC is not available in access).
0
Comment
Question by:ESmith
3 Comments
 
LVL 1

Expert Comment

by:almond_uk
ID: 2816955
Have you tried the FIX function?
0
 
LVL 2

Accepted Solution

by:
AlexJ030200 earned 50 total points
ID: 2817009
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
 

Author Comment

by:ESmith
ID: 2817317
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now