[AccessD] Convert text to number X posted

Hi Joe,
This is what I would do:
Create new Number Field in table
Update the NumberField with Key Vendor ID converted to number
Run a comparison check of Key Vendor ID and text value of Number Field
Do necessary clean up on records where not identical
Make the Number Field the new FK
Tick it Done!

Regards
Borge Hansen



----- Original Message ----- 
From: "Joe Hecht" <jmhla at earthlink.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>; "'ACCESS-L'" <ACCESS-L at PEACH.EASE.LSOFT.COM>
Sent: Wednesday, December 01, 2004 12:08 PM
Subject: [AccessD] Convert text to number X posted


> Finally found big trap in inherited database.
>
>
>
> Foreign Key Vendor ID is set as text. I need to convert it to long number.
>
>
>
> If I change data type to number Access threatens to delete all fields.
>
>
>
> I cannot find anything in help on Cnum.
>
>
>
> All thoughts apreciated
>
>
>
> JOE HECHT
>
> LOS ANGELES CA
>
> jmhla at earthlink.net
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


---
Outgoing mail is certified Virus Free by AVG Anti Virus System.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004