Solved

MS Access - Return a specific number of decimal places

Posted on 2015-01-19
2
136 Views
Last Modified: 2015-01-19
I'm doing some match on two field and would like to return X decimal places.

Right now I'm getting values like  

.71 / 481,534.86   = 1.4744519223385E-06

What I want to return is .0000015

Ideas?
0
Comment
Question by:keschuster
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40557773
Hi,

do you mean

Expr1: Round(0.71/481534.86;7)

Regards
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40557787
Dim numVal As Double
numVal  = .71 / 481,534.86
MsgBox Format(numVal ,"0.0000000")  ' for 0.0000015
'MsgBox Format(numVal ,"#.0000000")  ' for .0000015
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

856 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