PC Review


Reply
Thread Tools Rate Thread

Re: conditionally round decimal numbers from 8 places to 6 places

 
 
pietlinden@hotmail.com
Guest
Posts: n/a
 
      16th Jan 2007

Melanie O wrote:
> I have a table with numbers ranging from 0 to 777000.05. The data type is
> decimal, precision 17, scale 2.
>
> Is there a way to find the numbers that have more than 6 total digits (to
> the right and left of the decimal) and round off the remainder? So 777000.05
> becomes 777000, and 6.25 stays 6.25.
>
> Thanks,
> Melanie


use the Round function. You can specify how many significant figures
you want to keep. It may be under VB help.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtracting two 2-decimal place numbers gives result 13-decimal places? tsdutcher@earthlink.net Microsoft Excel Worksheet Functions 5 12th Mar 2007 11:38 PM
Re: conditionally round decimal numbers from 8 places to 6 places John Nurick Microsoft Access Queries 0 16th Jan 2007 10:22 PM
Re: conditionally round decimal numbers from 8 places to 6 places John Spencer Microsoft Access Queries 0 16th Jan 2007 09:54 PM
Round double to two decimal places =?Utf-8?B?UGF1bCBLcmFlbWVy?= Microsoft Access Queries 1 22nd Oct 2004 04:37 PM
Round double to 2 decimal places? =?Utf-8?B?UGF1bCBLcmFlbWVy?= Microsoft Access Queries 1 22nd Oct 2004 04:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:08 AM.