Last aggregate function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gus Chuch - 18 May 2008 12:46 GMT

The SQL Last function is to return the last value entered in a record, right?
The follow code will sometimes return the last entered value and sometime
not, why?
SELECT Last(tblEquipment.EquipmentID) AS LastOfEquipmentID
FROM tblEquipment;

Signature

thank You

Reply to this Message

Douglas J. Steele - 18 May 2008 16:22 GMT

Last doesn't return "the last value entered in a record", it returns "the
last value in a recordset". Since you cannot be sure of the order in which
records are returned if you don't have an ORDER BY clause in your SQL, you
can never be sure what Last will return for your query.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> The SQL Last function is to return the last value entered in a record,
> right?
> The follow code will sometimes return the last entered value and sometime
> not, why?
> SELECT Last(tblEquipment.EquipmentID) AS LastOfEquipmentID
> FROM tblEquipment;

Reply to this Message