After my CFDUMP is do see a number here is what I see I just changed anything important to 1234
CLT_MASTER_ID CLT_REF_NO CUR_BAL LIST_DATE NAME1 ORIG_AMT PMT_AMT
1 1234 1234 0 07/31/2003 1234 897 923.9800
----- Original Message -----
From: Tony Weeg
To: CF-Talk
Sent: Wednesday, January 21, 2004 11:43 AM
Subject: RE: Problems with Text in Access
have you <cfdump> 'ed the data to ensure its format?
a number is a number is a number when it gets to cf. make sure
access is spitting a "NUMBER" out, not something odd
tw
-----Original Message-----
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 11:34 AM
To: CF-Talk
Subject: Problems with Text in Access
Hello,
I have a problem with an Access database. I cannot switch to another
database. The problem is that there were numerical values being stored as
text. I am getting errors with I try to use Dollarformat() so I modified
the database column to be numeric, imported the database tables in to a new
table with Name AutoCorrect off.
This doesn't help I still get this error.
Parameter 1 of function DollarFormat which is now must be a number
I would like to fix the access issue. But if not is there a way to take a
string that is a number and convert it to a number then display it properly
as a dollarformat?
Thanks
Mickael
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
