T
Tina S
We have employees that our managers are required to review once a quarter.
They cannot do two reviews in one quarter to make up for missing a prior
review. I have created a crosstab query that lists all the employess and the
number of reviews on them by quarter.
I need to calcuate the managers quartly compliance. if they do 0 for the
quarter, it needs to be 0%. If they did 1 it needs to be 100%. If they did
2 or 3, etc, I need the % to still be 100% and not 200% etc.
How do I calcuate the % in a query?
How do I limit it to give me a maximum of 100%?
Here is what the crosstab query looks like:
Manager Name Employee Name Qtr 1 Qtr 2 Qtr 3
Mgr #1 name #1 1 1 1
Mgr #2 name #2 0 1 2
Mgr #3 name #3 1 1 0
Mgr #1 name #4 1 1 1
Mgr #2 name #5 1 2 1
ETC...
thanks.
They cannot do two reviews in one quarter to make up for missing a prior
review. I have created a crosstab query that lists all the employess and the
number of reviews on them by quarter.
I need to calcuate the managers quartly compliance. if they do 0 for the
quarter, it needs to be 0%. If they did 1 it needs to be 100%. If they did
2 or 3, etc, I need the % to still be 100% and not 200% etc.
How do I calcuate the % in a query?
How do I limit it to give me a maximum of 100%?
Here is what the crosstab query looks like:
Manager Name Employee Name Qtr 1 Qtr 2 Qtr 3
Mgr #1 name #1 1 1 1
Mgr #2 name #2 0 1 2
Mgr #3 name #3 1 1 0
Mgr #1 name #4 1 1 1
Mgr #2 name #5 1 2 1
ETC...
thanks.