[OZAPRS] Microsoft Access question

[main account]

select lat , long , callsign
from tblpositions
where  time like '?i*'

 ? = any character
1 = character
* anynumber of additional charcters

stephen  galowski

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


> 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
>
>
> __________ NOD32 1.443 (20030620) Information __________
>
> This message was checked by NOD32 Antivirus System.
> http://www.nod32.com
>
>

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