[AccessD] Function to grab decimal value?

Yep, and I keep forgetting Fix()

Just keep reminding me and SOMEDAY.... I might remember that one!

;-)

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, July 18, 2007 3:01 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Function to grab decimal value?

Hi John

Don't you have CInt() in mind? Int() and Fix() accept very large numbers.
Further, here Fix must be used in case of a negative decimal number.

/gustav

>>> jwcolby at colbyconsulting.com 18-07-2007 20:51 >>>
First of all, Int will only work for a value up to 32 (or 64) K.  Aside from
that, something like NewVal = MyVal-int(MyVal).   


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, July 18, 2007 2:37 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Function to grab decimal value?

Int returns just the integer portion of a value -- is there a counterpart
that grabs jus the decimal value? 

Susan H. 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com