Solved Table Fields calculation (1 Viewer)

The_Doc_Man

Happy Retired Curmudgeon
Local time
Today, 07:55
Joined
Feb 28, 2001
Messages
17,044
Our pleasure to help, silversun. Some of us will be here when you come back. (Of course, we are world-wide so have very different schedules.)
 

silversun

Registered User.
Local time
Today, 05:55
Joined
Dec 28, 2012
Messages
123
Silversun, please note that different people see the same things in different ways due to differences in background. Plog isn't wrong either. There are probably a dozen ways to approach this problem and you must find a method that works for you because you understand it AND it is technically feasible. June7, cronk, plog, and I have suggested that your structure is your enemy here. That "rat's nest" of relationships is the flare-lit tip-off that you have a problem of having overthought those risk findings.

Take a really hard look at that link plog gave you, then maybe come back and restate your original problem IN ENGLISH so that we can help you analyze your data and reach your goal.
Hi,
I was able to successfully fix the issue. With your suggestions I created a single table with all the values for risk measurements in it. Then using Column() property of each combo box it was easier than I thought to calculate the total with VBA under AfterUpdate event of each combo box.
Thank you all. You all gave me a hint to properly modify my db's structure.
Stay safe
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom