[AccessD] Getting last 3 records

Kaup, Chester A kaupca at chevrontexaco.com
Mon May 12 16:47:23 CDT 2003


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/113197eb/attachment.html>


More information about the AccessD mailing list