Adding table fields per Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

eIhave a table with EmployeeID, Leadership, Knowledge, Responsibility and
Planning.

Leadership, Knowledge, Responsibility and Planning receive a score.

I want to added these four fields per EmployeeID in a Query.

Also, is it possible to write the score to a Score filed in the table?

Thanks as always for the excellent help I get through this forum.
 
Charles

What you've described sounds just like ... a spreadsheet! Is there a reason
you aren't using a spreadsheet to track this?

It's rarely necessary (or desirable) to store a calculated value in a table.
Instead, plan to use a query to calculate your total score on-the-fly.

Also consider whether there is ANY chance that the number of factors (you
gave 4) will change over time. If so, you really don't want to have to go
back through your entire application changing the number of factors in
tables, queries, forms, reports, macros, code, ...! Your table structure
might benefit from further normalization.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Hi Jeff

I agree about the spreadsheet, I originally had it all in a spreadsheet, but
3000 employees made it difficult to find one particular person, as some
people using teh spreadsheet are not used to using filter and/or find.

I am trying Access and have one table with all the static employee details
and the second table, as described, with the evaluation data. I had thought
that adding a new evaluation filed would be easy with this layout.

I want to create a form showing both tables where the evaluation can be
input but I need the total

How would I add the four fields in a query to display on this form?

Charles
 
Charles

A common (and useful) approach to creating forms is to base them on a query.
If you create a query that displays the four fields, then add a fifth field
that does your calculation, you could use that query to "feed" your (new)
form.

And my suggestion about normalizing still holds...

If you set up three tables (tblPerson, tblQualification, trelEvaluation),
you could "add" a new factor to evaluate simply by adding a new row in the
tblQualification. To show which Qualifications a Person had completed (?!
is there a chance someone has NOT finished all 4 at once?!), the third table
only holds valid Person/Qualification scores.

To total up a Person's score, add vertically in the trelEvaluation table for
that Person's PersonID. This is done using the built-in Access Totals
query. Since only valid scores are included, you don't have to worry about
handling "missing" scores (as you do if you keep your
"horizontal"/spreadsheet structure).

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Hi Jeff

Thanks for the help, I think we are booth on the same track, you are just
clearer.

I will work on your suggestions.

Regards

Charles
 
Back
Top