Re: Comparing Employee Records

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Scott (Scott_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Wed, 27 Oct 2004 17:07:02 -0700

PC Data***,

Thanks!

I do want to produce a report before I correct so I can show HR how bad it
really is and get some support to change the process so this doesn't happen
again.

How would I produce the report?

"PC Data***" wrote:

> You don't need to do this manually!
> 1. Open the Training database to the database window and go to the tables
> tab
> 2. Click on File - Get External Data - Link and link to the HR database.
> Link specifically to the employee table in the HR database.
> 3. Create a query that includes the employee table from both databases.
> 4. Include the Position Title, Location and Supervisor fields from the
> Training database in your query.
> 5. Click on the query types button on the toolbar at the top of the screen
> and change your query to an update query.
> 6. Where it says "Update To" under each field, enter the corresponding
> field in the HR database
> 7. Run your query and the three fields will automatically be updated to
> the values in the HR database.
>
> --
> PC Data***
> Your Resource For Help With Access, Excel And Word Applications
> resource@pcdata***.com
> www.pcdata***.com
>
>
>
> "Scott" <Scott@discussions.microsoft.com> wrote in message
> news:8E4278A1-3161-4163-B111-22DC5AC52234@microsoft.com...
> > I am not a Access guru, hoping someone can help with this...
> >
> > I have two databases that contain employee data. One is managed by HR,
> and
> > the other by the training department. There are some differences in the
> > records caused by updates being made in one database and not the other
> when
> > promotions, transfers, etc take place. I have been advised that the HR
> > database is 100% correct because errors would be caught during payroll
> > activities.
> >
> > Here is what I would like to do. I have a primary key which is the
> employee
> > number. I need to validate/compare the information in the Training
> database
> > against what I have been told is correct in the HR database. Result would
> be
> > a list, or exception report, that shows me which employee records in the
> > Training database do not match those in the HR database. I would use
> these
> > results to update the training database.
> >
> > There are three main criteria I want to compare:
> > Position Title
> > Location
> > Supervisor
> >
> > I do not mind if this is done in one query or three.
> >
> > Example would be like this:
> > HR Database shows employee #123 as the Sales Manager in Atlanta reporting
> > to Jane Doe...
> > while the Training Database shows employee #123 as the Sales
> Representative
> > in Atlanta reporting to John Doe.
> >
> > Any suggestions?
> >
> > Thanks,
> >
> > Scott
>
>
>

Quantcast