I have a set of numbers in 2 tables that I’m trying to match, but there is a certain amount of error between them. Basically it’s a GPS log that I’m comparing to a data file to find the real location and of course there is an error.
Is it possible to build the error correction directly into the query or would I have to compare them in VB through an array?