[OZAPRS] Microsoft Access question

[Darryl Smith]

Stephen

That is a start, but I need it to be closest to, not like. I would assume
that the time would be within 5 minutes, but could be hours or days
different depending on the data

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  

-----Original Message-----
From: ozaprs-bounces at marconi.ics.mq.edu.au
[mailto:ozaprs-bounces at marconi.ics.mq.edu.au] On Behalf Of main account
Sent: Sunday, 22 June 2003 4:26 PM
To: ozaprs at marconi.ics.mq.edu.au
Subject: Re: [OZAPRS] Microsoft Access question


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


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