[AccessD] Getting last 3 records

You can use a subquery, have the subquery return the last three dates per
well.
 
Drew

-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at chevrontexaco.com]
Sent: Monday, May 12, 2003 4:47 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Getting last 3 records



I have a table that is full of oil well test data. Basically date and
volumes. There are dozens of records with different dates for each well.  I
need to get the average of the last (I.e. most recent)  three tests for each
well. Tried the top values but could not see how to do it for each
individual well. Your assistance appreciated.

No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030512/f311529a/attachment-0001.html>