Weekly summary field
Hello, I have one table called "Tests" which has one record for each Test and some results. One numeric result field is called "Efficiency." There is a field "Type" which is multiple-choice and can b...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you describe your tables in their relationships. Which is the one in which is the many for each relationship?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Mark,
The "Tests" and "Parts" tables are currently related with a 1 Part < many Tests relationship. However, I don't want to display the average Test "Efficiency" of the Tests currently related to this Part.
Instead, I want to display the average Test "Efficiency" of ALL Test records of Type "A" (for example) where the Test "Date Created" matches the Part's "Ref Date" field or is within the same week as the Part's "Ref Date."
So each "Part" record potentially has a different "Ref Date," and this would result in a different set of the full list of "Test" records to be averaged.
Does this make sense?
Thanks!
------------------------------
Graeme
------------------------------
