[OZAPRS] Microsoft Access question

[Darryl Smith]

People

I am attempting to use Microsoft Acces... And I am attempting to do a
funny
query... And I need some help. This is for my OziAPRS software...

I have a table called tblPositions. It contains the following fields
	Callsign *
	Time * 
	Lat
	Lon

Callsign and Time are Key Fields. Time is actually combined Date/Time.

What I want to do is to return the Lat, Lon, Callsign of __ALL_CALLSIGNS__
__CLOSEST__ to a given time. That is I want to find the where all my
trackers were at about midday.

This is not as easy as it sounds... Can anyone help?

Darryl

---------
Darryl Smith, VK2TDS   POBox 169 Ingleburn NSW 2565 Australia
Mobile Number 0412 929 634 [+61 4 12 929 634 International] 
Darryl at radio-active.net.au | www.radio-active.net.au  


_______________________________________________
ozaprs mailing list
ozaprs at marconi.ics.mq.edu.au
http://marconi.ics.mq.edu.au/cgi-bin/mailman/listinfo/ozaprs