A
Allen
I am using access to evaluate compensation. The comp data
comes regionalized and I use 3 data regions from a list of
about 10 different regions. The problem I am having is
when a position doesn't have all 3 data regions I then
want to use a total for all regions. Now the survey
already has the total regions sum so I am looking at a if
statement. If(these 3 regions are here, avg the 3
regions, not use total).
I have tried many different ways in a qry to get this to
happen with no luck. Is there a way to make this happen?
comes regionalized and I use 3 data regions from a list of
about 10 different regions. The problem I am having is
when a position doesn't have all 3 data regions I then
want to use a total for all regions. Now the survey
already has the total regions sum so I am looking at a if
statement. If(these 3 regions are here, avg the 3
regions, not use total).
I have tried many different ways in a qry to get this to
happen with no luck. Is there a way to make this happen?