How do I set up a task lists and followup dates in microsoft acce.

[Joseph]

I have to setup a database of all employees on my floor (about 100 people).
This tasks list will be for all new employees and current employees, when a
new employee is hired they need to fill out forms and then 6 months later to
an evaluation. Then for all employees they need to do year evals and
education requirements. How can I set this up so when it comes time to do
evals, access wil notify the manager and then reset the date for next year.

 

[RobFMS]

Here are some recommendations:

1. Create a field called "HiredDate" (datetime datatype). This is the date
the person started with the company.
2. Create a field called "EvalDate" (datetime datatype). This is the date
the person had their 6 month evaluation.
3. Create a field called "AnnualDate" (datetime datatype). This is the date
the person had their annual evaluation.

To determine who did not get their Evaluation review in 6 months:
Select <fields>
From <table>
Where EvalDate Is Null

To determine who did not get their Annual review:
Select <fields>
From <table>
Where ( EvalDate Is Null ) and
( (AnnualDate Is Null) or
( Year(AnnualDate) <> Year(Date) )
)


This is off the top of my head. I believe this should give you some movement
forward. Let me know how it goes.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have to setup a database of all employees on my floor (about 100 people).
This tasks list will be for all new employees and current employees, when a
new employee is hired they need to fill out forms and then 6 months later to
an evaluation. Then for all employees they need to do year evals and
education requirements. How can I set this up so when it comes time to do
evals, access wil notify the manager and then reset the date for next

year.