Posted by Steve on 11/30/06 20:10

"Pupkin" <spamagnet@dorrk.com> wrote in message
news:MPG.1fd8d961be5fb3e398978d@news.giganews.com...
| Thanks, but I think I need the reverse of this. I don't have two points
| from which to equate the distance. I have one point, from which I need
| to be able to find all other points in the database within a, say, 50
| mile radius.

no...u DO have two locations. one for each store and one for the address the
user enters. you need to calculate, in a query, the distance between all
your stores and the user's address...only returning those within n distance.

| I have no experience with cartography, but my gut feeling is this math
| does something different than what I need. I'll poke around a little for
| help on how to calculate differences in longitude and latitude.

it calculates distance. that is exactly what you need in order for this to
work! poke around but you won't find much out there.

gift horse...mouth...

[Back to original message]