Access Tip: Salary History

News User Comments History Notify Me

2/1/2018 4:03:20 PM
Access Tip: Salary History
By Richard Rost

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

Permanent Link
Keywords: access tips

Post Reply

Access Tip Salary History Comment from Dwayne @ 3/20/2019

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.

Thanks, Richard.

Show Just This Thread Post Reply

Access Tip Salary History Comment from Carolyn L @ 2/2/2018

Thank you.

Show Just This Thread Post Reply

Access Tip Salary History Comment from Chris B @ 2/2/2018

Good to hear you again, buddy.
Regards
Chris

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 6+9:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard