Search results

Thank you theDBGuy, it works perfectly! You saved me so much time.

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...

I have a database where for each person (ID), I need to calculate the most adverse score by weight (0 is worse than a 10) by section. See SectionRollup for expected value. For each ID and SectionTitle, what score has the highest (max) weight? ID SectionTitle Score Weight SectionRollup...

Yep! And free!

I am an experienced Access user but am always looking for ways to make improvements through VBA. I work in the insurance industry and have built several Access UI's for users to complete data entry into our Master Data Management tables. These UI's are made using forms linked to SQL Server...