art, Thanks for the reply, I can see how it would be possible with sql, though a bit complex. Would still prefer to be able to compare each row of file1 with every row on file2. The data would be from a survey on a 50 x 50 meter grid where file1 would contain two numerical values x1 y1 where one unit represents 50m with the origin at say 0 0. file2 would contain a grid x2 y2 with an origin of 25 by 25. Rows in file1 represent points that cannot be accessed and need to be moved by a maximum radius to a point on the second grid such that points from file1 will be allocated to points in file2 only once and points in file2 will only be matched with a point from file1 once. Both files could be in the thousands. Regards, Allan.
... View more
