I IanT Registered User. Local time Today, 19:59 Joined Nov 30, 2001 Messages 191 Oct 18, 2005 #1 I am linking to a table in Sage then making a table. One of the fields is a number format, how can I change the format to text!
I am linking to a table in Sage then making a table. One of the fields is a number format, how can I change the format to text!
john471 Registered User. Local time Tomorrow, 06:59 Joined Sep 10, 2004 Messages 392 Oct 18, 2005 #2 Don't know anything about Sage, but have you tried something like SELECT CStr([fldNumeric]) AS fldText INTO tblNewTable FROM tblLinkedSage; (using the cstr function). HTH Regards John.
Don't know anything about Sage, but have you tried something like SELECT CStr([fldNumeric]) AS fldText INTO tblNewTable FROM tblLinkedSage; (using the cstr function). HTH Regards John.
john471 Registered User. Local time Tomorrow, 06:59 Joined Sep 10, 2004 Messages 392 Oct 18, 2005 #3 By the way.... Why would you actually want to do that ????
