In this Microsoft Access Tutorial, you will learn how to track an employee's complete salary history using an Aggregate Query and the Max function.  This will allow you to store the complete history but be able to calculate what his current salary is.

Click here: ACCESS SALARY HISTORY

Access Tip Salary History Upload Images   Link  Dwayne  2 years ago This tip works great to find the employee's current salary. I know also that you can use the Min function to find the employee's starting salary. But, my question is how would you find employee #2's middle salary? I have a database where we track salary over the entire year and in some cases the employee may be promoted/demoted multiple times in that period. So I need to be able to find multiple salaries throughout the year. Read More... Thanks, Richard. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tip Salary History Upload Images   Link  Carolyn L  3 years ago Thank you. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tip Salary History Upload Images   Link  Chris B  3 years ago Good to hear you again, buddy. Regards Chris Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.