how do I get an average value of all the records of a piece of equipment with a specific make and model so I can compare that to my current found set for that same make and model.
Sounds like you need yet another relationship that matches by equipment type only or an execute SQL that does the same.
Thanks Phil. You mean equipment type like "Main ENgine Port" or Make and Model like Volvo 9000?
You know how your data is set up and what you want better than I do.
What I can tell you is that the key will be a relationship that matches only to records for the specified "type". That may require matching by a single field or multiple fields, it depends on your data and what you need for that total value.