I'm trying to come up with a 3rd query or include in the 2nd query the ability to drop in the group# that is associated with the losses in query2. For example, record 1 in query 2 lists "8234". I'd like to have the result list group# 2 as it is greater than 8000 and less than 15000. Record 3 of query 2 would have a result of group# 1 as it is less than 8000 and greater than 0.
Would anyone have any ideas to accomplish this? Any help would be appreciated thanks!