[AccessD] Break a float into it's parts

Stuart McLachlan stuart at lexacorp.com.pg
Fri Feb 2 09:04:58 CST 2007


Use  Fix() for the integer part. (Int() will screw up on negative numbers)
Use Abs(myNum - Fix(myNum)) to return the decimal part - assuming you 
always want the decimal part positive.


On 2 Feb 2007 at 9:37, JWColby wrote:

> 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

-- 
Stuart





More information about the AccessD mailing list