Gustav Brock
Gustav at cactus.dk
Wed Jul 18 14:01:12 CDT 2007
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.