View Single Post
  #1  
Old June 7th, 2010, 09:06 PM posted to microsoft.public.access.tablesdbdesign
AccessKay
external usenet poster
 
Posts: 106
Default Suggestions for table or query to track movement

I have a table for employees that includes the usual description fields for
employees. This is one of my master tables with the employee ID being the
primary key. Then I have another table that stores all employee hours that I
add on to monthly via an import from Excel (emplID is foreign key). I want
to keep track of all of the employees that are new or terminate. I’d like
Access to recognize if an employee is missing or new and later be able to
create a report for recent new hires or terminations. I may be expecting
too much and if so please give me your opinion on this. It wouldn’t be that
big of a deal to track it manually but I wanted to see if anyone had any
suggestions.

Thanks for any help.