Solved

Truncate values in Access

Posted on 2000-05-17
3
992 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 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

10 Experts available now in Live!

Get 1:1 Help Now