Problem with two averages in report

[mejia.j88]

Hi all,

I have a report in which I am calculating two averages. there is a field under the detail header called [resistivity], the report is grouped by days, and there are at most 4 entries per day. One of the averages is a daily average; for that i simply put a text box with =avg([resistivity]), call it daily average, and put it under the date footer; the works fine.



the other average should be an average of the daily averages.
the report is viewed by date range, so the amount of days selected could vary.

i am not sure how to make my report show the average of these daily averages based on the date range selected.

help please?

[June7]

Do you want to provide project for analsis? Follow instructions at bottom of my post.

[mejia.j88]

sure thang,

[June7]

You did not attach the db, just the shortcut from desktop.

[mejia.j88]

DI_Water_Resistivity_forAutomatic_Junction_Etch_Rinse.zip

sorry about that.

thanks for taking a look at it.

[June7]

Why are you saving date/time values to text instead of date type field?

Also, you use Date as an alias field name. Date is a reserved word (it is a function) and should not be used as name. I changed to DateLog.

The report has code referencing tbl_revisions not provided with the db so get error message. I deleted the code so report would run without error.

Try:
1. build query qry_report_average
SELECT qry_report.DateLog, Avg(qry_report.Resistivity) AS AvgOfResistivity
FROM qry_report
GROUP BY qry_report.DateLog;

2. build subform in report footer using the above query OR use DAvg in textbox in footer: =DAvg("AvgOfResistivity","qry_report_average")

[mejia.j88]

Hi June,

I must have sent the first draft of the db, regardless, your advice has helped me with that little problem.
i double checked the revised version of the db to make sure i didnt use any "date"/"time" names and changed the date value to date/time.
the DAvg in textbox in footer worked great; thanks