John W. Colby
jwcolby at colbyconsulting.com
Tue Nov 30 20:35:57 CST 2004
I would copy the table STRUCTURE to a new table, same name, with a 1 on the end. Now the new table is empty. Change the PK to an autonumber. Build an append query to append the data from old to new. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Tuesday, November 30, 2004 9:09 PM To: 'Access Developers discussion and problem solving'; 'ACCESS-L' 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