find average of values in a totals query

[tagteam]

I am running a totals query that takes line items, combines them by filename and then sums a value. that may end up showing me 10 lines with a sum for each line. How can I add a column that will show me the average of those sums. Since I cant do a total at the bottom and I don't want to use a report i realize it will show the same value at the end of each row, if it is even possible

[ranman256]

you already have Q1 to get the 10 sums,
then make Q2 that uses Q1 to get AVG.

[tagteam]

I am not sure that gives me what I want.

I would like

file cust total avg
file1 cust1 10 19.8
file2 cust1 25 19.8
file3 cust1 32 19.8
file4 cust1 10 19.8
file5 cust1 22 19.8
file1 cust2 10 15
file2 cust2 15 15
file3 cust2 20 15
file4 cust2 15 15

I don't know if this is possible because I want the average for that customer over a period of time to show at the end of each row.

[Bulzie]

Maybe make query with 3 fields with GroupBy on cust column, Count on cust column(CountOfcust) and Sum on total column(SumOftotal). Then 3rd query using that query with Avg: SumOfTotal / CountOfcust. You could like this 3rd query back to the first one you posted by cust to combine both to add the avg. Probably better ways in code maybe using DCount an DSum to get the average.

[tagteam]

good thought on the dcount. I will give that a try