Need help getting access to assign numbers based on 3 fields

  • Thread starter Thread starter Stu925
  • Start date Start date
S

Stu925

Here's the situation, I need to create a seniority list of employees
based on 3 fields in the database. I need Access to assign seniority
numbers based on those fields. The three fields are in order of
importance, seniority date (date hired), Test score, and a scramble
code number assigned by our employer. I also need these numbers to not
be static, say if the #1 man in seniority retires and gets deleted from
the database I need the other 359 or so other seniority numbers to
change accordingly and automatically so that the #2 man automatically
goes to #1 when the #1 man retires. Is this possible in access or will
I need an actual program for it. Can anyone help me with this?

Stu
 
Stu925.zndq1 said:
Here's the situation, I need to create a seniority list of employees
based on 3 fields in the database. I need Access to assign seniority
numbers based on those fields. The three fields are in order of
importance, seniority date (date hired), Test score, and a scramble
code number assigned by our employer. I also need these numbers to not
be static, say if the #1 man in seniority retires and gets deleted from
the database I need the other 359 or so other seniority numbers to
change accordingly and automatically so that the #2 man automatically
goes to #1 when the #1 man retires. Is this possible in access or will
I need an actual program for it. Can anyone help me with this?

Stu
Click to expand...

Hi Stu,

Since the seniority value is a calculation, it's probably best to not
store it at all. You can create a query that will return the active
employees in order by date hired (ascending), test score (descending),
and scramble number (ascending).

Because it's a query, when an employee retires (and they're no longer
active) they'll automatically drop off the list.

If you want an actual seniority number, you could number them
sequentially in a report, but this number would not be stored anywhere.

Hope this helps,
 
Back
Top