I have this problem in probability that defies me and I need the help of Access experts.
I have a query which provides probability of occurrences for items A,B,C,D below 5, 10, 15 and 20.
Yet another query gives probability of occurrences for items A,B,C,D above 5,10,15 and 20.
Now I need the combined probability for each of the items A,B,C,D.
Please help me with the SQL.
What is available and what is needed are both attached.
Regards
I have a query which provides probability of occurrences for items A,B,C,D below 5, 10, 15 and 20.
Yet another query gives probability of occurrences for items A,B,C,D above 5,10,15 and 20.
Now I need the combined probability for each of the items A,B,C,D.
Please help me with the SQL.
What is available and what is needed are both attached.
Regards