Re: Multiple LOV results
From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Sun, 22 Oct 2000 10:54:49 GMT
Message-ID: <ZHzI5.11883$ze4.2077588_at_typhoon.tampabay.rr.com>
Date: Sun, 22 Oct 2000 10:54:49 GMT
Message-ID: <ZHzI5.11883$ze4.2077588_at_typhoon.tampabay.rr.com>
select columns
from mytable
where tabledate = (select max(tabledate)
from mytable)
/
Scott <swesley_at_student.ecu.edu.au> wrote in message
news:39F255EB.A2A627F1_at_student.ecu.edu.au...
> G'day
>
> I have an lov which lists multiple entries in a table (as expected), but
> I would like to limit this list to one - the one most recent date (a
> field in the table).
> I've tried using max(tabledate) - doesn't work, and I can't identify
> where in the help I should look.
>
> I would appreciate any direction...
>
> Thanks.
>
>
Received on Sun Oct 22 2000 - 12:54:49 CEST