Need help with coordinates query

[matt_fdz]

I need help running a query to find the nearest coordinates for two separate tables. I have table one with field X and field Y and table two with field X2 and field Y2 and i need to run Sqr(([X]-[X2]^2)+([Y]-[Y2])^2) to find the coordinates from table two which are closest to the coordinates from table one. This will require the formula to be ran against each record of both tables and then display the minimum value for each. Any ideas on how to set up relationships and query to accomplish this?

[orange]

This sounds like a homework or test assignment.
Please tell us more.
What is your plan of attack? Can you show us some sample data?

Here's a link that may help you.
But this one may give you more info.

Good luck

[June7]

I think the formula has a misplaced ) following the first ^2.

Maybe a Cartesian relation and aggregate query.

SELECT X, Y, X2, Y2, Min(Sqr(([X]-[X2])^2+([Y]-[Y2])^2)) AS MinDataCalc FROM table1, table2 GROUP BY X, Y, X2, Y2;

[matt_fdz]

Orange, it's actually just a personal project I'm working on.

And June7, I did misplace the parenthesis on my post but after looking back at the query I had started it was right. I ran the query you gave me and it worked to calculate the distance for all the values of both tables, but it didn't narrow the results to just the minimum value so now I have a bunch of duplicate coordinates displaying a distance for every value in table 2. Now I've got something to work with, but how can I get it to display just the minimum distance for each duplicate?

[matt_fdz]

Solved it ... Thanks for the help... Just ran a separate query after the one June7 gave meand since all I'm really concerned with is the distance from each coordinate the query below worked just fine

SELECT SpotsinArra.X, SpotsinArra.Y, Min([MinDataCalc]) AS DistanceFROM SpotsinArra LEFT JOIN PreFinal ON (SpotsinArra.Y = PreFinal.Y) AND (SpotsinArra.X = PreFinal.X)
GROUP BY SpotsinArra.X, SpotsinArra.Y;