Posted by Roy Harvey on 06/26/07 13:19

On Tue, 26 Jun 2007 12:42:49 GMT, "Dan Guzman"
<guzmanda@nospam-online.sbcglobal.net> wrote:

>
>> >When using the 'Last' function, do you have to have the columns sorted
>>>by when they were entered?
>>
>> What 'Last' function? I did not use any such function, and have not
>> heard of any such function.
>
>FIRST and LAST are non-relational aggregate functions in Access. In the
>latest version of Access, these return the first and last values of an
>ordered set. However, the returned values are arbitrary when the result is
>unordered and I don't think the result is well-defined in many cases.

Thanks for clueing me in, Dan!

Roy

[Back to original message]