Posted by Tyrone Slothrop on 11/03/06 05:47

I need to write a query which will find those records which have the
closest values to a zip code posted through a form. The values may be
greater than or less than the requested value.

I had written a function which accomplishes this which uses multiple
queries many years ago. As I am now revising the site in a major
redesign, the thought occurred to me that there must be a better way.

Any ideas?

[Back to original message]