[AccessD] Text to Number Conversion Problem

Never mind.  Figured it out.  Cdbl will do it. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, November 10, 2008 5:57 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Text to Number Conversion Problem

Dear List:

Legacy system.  The previous designed defined a numeric field as text.
Don't know why. BUT...

When the field contains a comma it doesn't convert right when converted to
numeric (for use on a report in this case).

IOW, the user enter 39000 and everything's OK.  The user enters 39,000 and
the report says 39. Drops everything after the comma.

The right solution, of course, is to convert the back end to numeric.  And I
may urge him to do this.  Have to convert the data as well making sure that
39,000 converts to 39000 and not 39.

Nevertheless, short of doing the 'right' thing, is there a way to get the
text 39,000 to convert to the numeric 39000 instead of 39?

MTIA



 	
	
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 


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