Hi.
After employees have been with my organisation for two years, they get a
payrise.
Employees only have to wait for two years to receive their first pay raise?
If these are high quality employees, better hope that they've never heard the
story that starts out, "Once upon a time there was a large company who shall
remain anonymous, but whose initials are G.E. . . . " In case you haven't
heard the story, please see the link to the article, "Education vs.
Experience" on the following Web page:
http://www.Access.QBuilt.com/html/articles.html
I have a desktop diary which flashes up warnings for events, can
Access do the same?
Generally, companies schedule pay raises at the time of the annual
performance review, so the alert to schedule the annual performance review in
your "desktop diary" would be the alert to do the associated tasks as well,
including change the employee's salary to reflect the pay raise for the next
pay check.
There are quite a number of ways to set up such an "alert" within Access,
however. One simple way would be to open the "front page" form in Design
View and create an unbound list box on your form, and then create a query
such as the following to populate it:
SELECT ID, FName & " " & LName AS FullName, EmpStartDate
FROM tblEmps
WHERE (DateAdd("yyyy", 2, EmpStartDate) <= Date())
ORDER BY EmpStartDate DESC;
.. . . where tblEmps is the name of the table containing the employee
records, ID is the primary key, FName is the employee's first name, LName is
the employee's last name, and EmpStartDate is the employee's start date. The
most recently hired employees that have at least two years seniority would be
at the top of the list.
In the list box's Properties dialog window, place the name of the query in
the Row Source Property, and set the Column Count Property to 3 and the
Column Widths Property to 0";1.5";1" so that only the second and third
columns of the query will be displayed in the list box. Open the form in
Form View to view the names of the employees with more than two years of
employment history.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.