Jim Lawrence
accessd at shaw.ca
Fri Feb 2 13:13:08 CST 2007
Hi John: intNumber = int(23.456) lngNumber = 23.456 - intNumber intNumber = 23 lngNumber = .456 Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Friday, February 02, 2007 6:37 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Break a float into it's parts How do I get the integer part and the decimal part of a floating point number 23.456 how do I get the 23 how do I get the .456 Using clng for example "rounds" the number up or down which isn't what I want for the integer portion John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com