Performance Evaluation Question

[twitchie]

I have searched on this forum for other threads like this and in the db examples page, but didn't find anything. I have made a perfomance eval db in MSA 2003. It works fine except for one part. I need to score the individual on about 20 different criteria. Each one ranges from 1-5. I am having problems getting all the entries to sum when I run the report. Should I use combo boxes, check boxes, radio buttons or what? Then how do I get the individual scores to sum up when I am finished putting them in and run the report to print it? I have looked around the net for a Performance Evaluation template to see how it is done, but couldn't find one anywhere. Microsoft doesn't have one in their list of templates either. If anyone knows where to find one at, I'd appreciate that too. TIA for your help! I appreciate it.

James

 

[neileg]

I suspect that your db isn't normalised. You probably have 20 different fields in your record rather than 20 different records in an associated table.

Still, you should still be able to sum your 20 fields in a query. Use a calculated field like this:

MyTotal: MyField1+MyField2 +...+MyField20

If there's a chance that any of the fields are null, you should use the null to zero function:

MyTotal: Nz(MyField1)+Nz(MyField2) +...+Nz(MyField20)

 

[twitchie]

Thanks for the help. I did a little research on normalization and it gave me some ideas. I appreciate it.

 

[hdblue]

Thanks for the help. I did a little research on normalization and it gave me some ideas. I appreciate it.

Hi,

Thanks for posting. I want share some my ideals.I'll share soon again

Apart from that, you also can ref more resources at: humanresources.hrvinet.com/performance-appraisal-phrases

Best rgs.