average of averages?

[mejia.j88]

hi all,

i am creating a report that requires some averages. Each row in my query serves as a record for a part number, and each part number gets measured 3 times.
the average i have right now is given by ([measurement1] + [measurement2]+[measurement3])/3 and this is in a new field called
PostEtchM in my query.

in my report, i want to be able to take the average of these averages.
for example,
my report will say something like



part number average etch
RSX1234 0.0894

but that 0.0894 will be the average of all of the averages for that specific part number.

how do i go about creating this new average if the amount of records for part numbers vary?

[Robeen]

How are you getting [measurement1], [measurement2] and [measurement3]
. . . into one row of your Query [to reference them in your new field Avg. Calculation] - if they are in three different rows in your Table?

Or am I misunderstanding?

[mejia.j88]

i think a snapshot of the query will clear things up.

the measurements1,2,3 are different columns, each row will have an try for the fields.

[Robeen]

Have you considered creating a second query that uses the above query as its source?

Then you can Group the fields in your first query that are identical [like ID and PartNumber] - and 'Average' the postAVG field.

[mejia.j88]

thanks robeen, that worked great!

[Robeen]

happy I could help!