Select last three records in a recordset

[sbbrown9924]

How would I select the last three records in a recordset?

 

[sbbrown9924]

Never mind....

Select LAST(TriageTime) AS LastTime, LAST(TriageTime) - 1 As SecondLastTime FROM....

 

[mp9]

Alternatively:

SELECT TOP 3 TriageTime FROM.....
....ORDER BY TriageTime Desc;

http://www22.brinkster.com/accessory/

 

[sbbrown9924]

mp9;

Cool. That works great!

Do you have a good reference source you can recommend? I cannot find any information about TOP in ADO, VBscript, ASP or JET SQl reference guides. Is TOP part of VB basic? Thanks again.

 

[sbbrown9924]

What if I want to compute the average of the three values derived from this query?

SELECT TOP 3 round(DateDiff('n', DispositionTime, NOW())/60,2) AS TopThree
FROM TrackingMain
WHERE DateDiff('n', DispositionTime, now()) > 120 AND AdmittingService=1

 

[mp9]

TOP is part of JET SQL.

Open you Access Help file and, from the Contents tab, expand Microsoft JET SQL Reference. Under Overview you'll find a topic called SQL Reserved Words. You'll find a clickable link for Top there.

Alternatively,

http://www22.brinkster.com/accessory/queries/004.shtml

for a quick summary of all you need to know about Top.

 

[lespaul]

SELECT AVG(TopThree) As TopThreeAvg FROM (SELECT TOP 3 round(DateDiff('n', DispositionTime, NOW())/60,2) AS TopThree
FROM TrackingMain
WHERE DateDiff('n', DispositionTime, now()) > 120 AND AdmittingService=1)

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[sbbrown9924]

mp9, lespaul;

Ah, the missing link! In the reference guides I use, they don't mention reserved words. Thank for helping me withe query.