average triplicates

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

In my database I have records which are related by several fields,
i.e. a lab id, date and site id.  I would like to loop through the
queried records and pull out the unique triplicate records and average
their field values.

Can anyone suggest a way to do this?  I am a beginner but I have
achieved everything in my script up to this point.

Re: average triplicates


Quoted text here. Click to load it

The keywords to look for are GROUP BY and AVG(), but for details and
better explanations you should ask in a database group.


Re: average triplicates

qtrimble wrote:
Quoted text here. Click to load it

Let the database do it.  See a newsgroup related to your database.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline