Summarizing control based on unique values different field

B

BRC

I am trying to create a control that sums a field “tstresult” for
unique “eventid” in a query that may contains multiple records with
the same “eventid”. When I use =sum([tstresult]) in the control
source it adds all test results. I can’t do this based strictly on
unique values of “tstresult” because the different “eventid’s” could
have the same “tstresult”. Thanks in advances for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top