Solved

MS Access - Return a specific number of decimal places

Posted on 2015-01-19
2
135 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 49

Accepted Solution

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

do you mean

Expr1: Round(0.71/481534.86;7)

Regards
0
 
LVL 33

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

777 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