Listers, Many thanks for all the responses I received, especially Warren Vick and Laurence Seeff. I used Laurence's suggestion to achieve the result but I'd still like to see your code Warren, just not so urgently now!
See below for the process I followed: * Copy your zone file to a new name (lets say "zones2"). * Add a field to both files (zones1 & zones2) containing the same value throughout (id_dummy with a value of 1 in each field). * Change the names of X and Y fields in both table to read X1 Y1 and X2 Y2. * Perform an SQL select using the two tables where id_dummy=id_dummy . This will give you a matrix of 77*77 - id_dummy has a value of 1 for all records. With 77 zones I ended up with 5929 rows of data. * I then saved the query as a table in its own right and added a column called "Distance". * You must the set your coordsys it seems, this had me stumped for a while as the update was not working. * Then perform the update - Update Matrix_77 Set Distance = Distance(X1,Y1,X2,Y2,"km") * I then created lines for each of these so that I could perform a manual check on the distances - Update matrix_77 set obj = CreateLine( x1 , y1 , x2 , y2 ) Thanks again! Best Regards, David ---------------------------------------------- David A. Eagle (GIS Consultant) Atkins Design Environment & Engineering Cornerstone House Stafford Park 13, Telford Shropshire, TF3 3AZ England Tel: +44 (0)1952 21 3268 * Fax: +44 (0)1952 20 0981 * Email: [EMAIL PROTECTED] * Web: www.atkinsglobal.com <www.atkinsglobal.com> * This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
