[OZAPRS] Microsoft Access question
sgalow at ihug.com.au
Sun Jun 22 16:25:57 EST 2003
select lat , long , callsign
where time like '?i*'
? = any character
1 = character
* anynumber of additional charcters
----- Original Message -----
From: "Darryl Smith" <Darryl at radio-active.net.au>
To: <ozaprs at careless.net>
Sent: Sunday, June 22, 2003 2:26 PM
Subject: [OZAPRS] Microsoft Access question
> 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
> __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
> __________ NOD32 1.443 (20030620) Information __________
> This message was checked by NOD32 Antivirus System.
ozaprs mailing list
ozaprs at marconi.ics.mq.edu.au
More information about the Ozaprs