JWColby
jwcolby at colbyconsulting.com
Thu Sep 7 17:23:18 CDT 2006
Very good! I knew single had precision limitations, I just didn't have the time to go discover what they were. 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 Stuart McLachlan Sent: Thursday, September 07, 2006 5:45 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Numbers On 7 Sep 2006 at 16:57, JWColby wrote: > Probably a single. No! Maximum precision 7 places. That would store and manipulate it as 34567900000000 >> What would you dim the following number as in VBA >> >> 34567899999999 >> >> In order to carry out math on it. You will have to use either a Double or Currency. Which one depends on what sort of math you want to do. Double will allow you to use larger numbers but currency will give you greater precision. -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com