Salary Increases

[cabcree]

I'm not even sure how to word this to search for an answer, so I apologize if this has already been addressed in some way (or if this is in the wrong forum).

I need to do figure out a way to see who got a raise this last year. I have around 800 people to look at and would love to do this in an easier way than to search through each record.

So basically I'm hoping I can create a query that if they went from $1800 to $1900 (amount varies person to person) in the year that it would show their names. However, I'm not sure it is possible to do a query...maybe some other way? VBA?

Even a nudge in the right direction would help. Thank you

 

[SOS]

It all depends on how your data is stored. How is it stored?

 

[cabcree]

it's stored in tables. is that what you mean?

 

[Brianwarnock]

How can it be possible without looking at every person.
If the previous and current salary are held it is obviously easy, if not impossible.

Brian

 

[SOS]

it's stored in tables. is that what you mean?

What is the make up of those tables? For example, do you have a record that is saved for each salary value? In other words, you have something like:

SalaryID (PK)
EmployeeID (FK)
Salary (value)
EffectiveDate (date)


so that you can get any history from your increases?

 

[Khalid_Afridi]

@ Brianwarnock Good question...

 

[cabcree]

What is the make up of those tables? For example, do you have a record that is saved for each salary value? In other words, you have something like:

SalaryID (PK)
EmployeeID (FK)
Salary (value)
EffectiveDate (date)


so that you can get any history from your increases?

Very close to that, yes.

EmployeeID (PK)
Work Field (date)
Salary (value)

plus a few other fields. I don't have anything similar to SalaryID.

 

[Brianwarnock]

So you have no history of salary or the date when the current salary became effective?

Brian

 

[Khalid_Afridi]

Its seems the database is not normalized properly.

 

[Khalid_Afridi]

lot of ppl are watching for salary increased, perhaps they want to know if there is a function which could increase their salaries... lol

 

[SOS]

lot of ppl are watching for salary increased, perhaps they want to know if there is a function which could increase their salaries... lol

If you come up with one I can "slip in" to my company's payroll system without them noticing, let me know

 

[cabcree]

I'm not sure if this will help...

Each person's beginning salary varies. I work with part-time faculty who may or may not work each term (a term is 1/2 a semester). Their starting salary varies on their experience and what degree they hold. The rules for an increase is if they have taught five classes. It doesn't have to be within any type of time period. It might take five years for them to get an increase as they might only teach one class a year. Does that make sense? With that information, can I set up up a way to have a current salary table? Am I making sense?

Funny, Khalid_Afridi.

 

[Khalid_Afridi]

If you come up with one I can "slip in" to my company's payroll system without them noticing, let me know

We all are trying our best SOS, I will let you know once it is done..

 

[Brianwarnock]

I guess anything is possible if the information is there, but it doesn't appear to be, anyway wouldn't it be simpler to just carry the date of the last salary change.

Brian

 

[Khalid_Afridi]

I guess anything is possible if the information is there, but it doesn't appear to be, anyway wouldn't it be simpler to just carry the date of the last salary change.

Brian

This also a nice point, but how to know if it is changed?
There should be two new columns in the same table which represent the last salary changed and the effective date respectively.

 

[cabcree]

thanks all for your help! looks like I need to re-think this and add some fields.

 

[accessfever]

i wonder if you have a backup database from last year? If you do, then you can compare two tables if there are any change. If not, then i don't know.