Re: Multiple LOV results
From: Aca Vasic <acko_at_ni.ac.yu>
Date: Wed, 1 Nov 2000 09:40:21 +0100
Message-ID: <8tokqo$l6t$1_at_zmaj.etf.bg.ac.yu>
Date: Wed, 1 Nov 2000 09:40:21 +0100
Message-ID: <8tokqo$l6t$1_at_zmaj.etf.bg.ac.yu>
The problem is in You select statement
It probably should look something like this:
select ...
from ...
where tabledate=(select max(tabledate) from ...))
"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 Wed Nov 01 2000 - 09:40:21 CET