how to query by distance
-
Hi guys I've have set up a data-table in MS Access. I have a colomn with the names of my data and a column with numbering of the data (One number for each name). I then have a new entry of data, which I want to compare to the data in my table. I want to do this by calculating the distances between the new data and all of the data (numberings) in the data-table. Finally I want to choose the ten data-items from the tables, which have the shortest distance to the new data-entry. My problem is... How can I in sql-code calculate the distances, one row at a time - save them and later compare all the distances and choosing the ten shortest ones. I haven't done much sql-code before - so i would really apreciate any suggestions or maybe some good links Thanks in advance AL