microsoft.public.access.reports

Allen,

How can I use that Formula in a query, where I want the query to find all
the Lat/Lon geocodes in a table for a given reference Lat/Lon on the form?.
I'm not a seasoned VBA coder, but know my way around a little.


"Allen Browne" wrote:

> Hi Mark
>
> One way to do this would be to store the precise latitude and longditude of
> each city, and then use great-circle trig. to calculate thd distance between
> different places:
> http://en.wikipedia.org/wiki/Great-circle_distance
>
> Microsoft did release a Neatcode.mdb that contains the VBA functions to
> handle great-circle calculations. I can't see a more recent one, but this
> was for Access 95, so you should still be able to convert it into your
> version:
> http://support.microsoft.com/kb/148402/en-us
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Mark A. Sam" wrote in message
> news:et%238ESNDIHA.5044@TK2MSFTNGP03.phx.gbl...
> > Hello,
> >
> > I need a report filtered by the distances of cities based on a starting
> > city (radius search). For example, if the starting point is Buffalo NY, I
> > want the records within a specified radius of that city. My method would
> > be to produce a temporary table with distance field then use that as the
> > criteria for selecting the report results.
> >
> > What I am looking for is a program which will allow me to calculate that
> > field from Access and to return the result to the Access table. An Access
> > program would be preferrable, but unlikely.
> >
> > Thanks for any help.
> >
> > God Bless,
> >
> > Mark A. Sam
>
>