I can't figure out how to do a totals query or DMax formula that takes two columns into account and then to dump the result in a new column.
DMax(«expression», «domain», «criteria») ----- my interpretation: Dmax([CaseData.].[Weight]),[CaseData],???)
See attached - let me know if more info would...