[OZAPRS] Microsoft Access question

Darryl Smith Darryl at radio-active.net.au
Sun Jun 22 14:26:21 EST 2003


I am attempting to use Microsoft Acces... And I am attempting to do a
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 * 

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 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

More information about the Ozaprs mailing list