Sorting/Record Selection

K

KenP

We work on a bi-monthly (every two weeks) payroll. Each payroll I download an
Excel spreadsheet containing employee payroll information into Access 2003. I
need to know how to take current download, compare it against last payroll
data and determine who is a new employee. In other words, I need to know what
is easiest way to determine who is included in current payroll download that
was not in last payroll list/download.

Any help will be greatly appreciated. Thanks and have a great day.
 
J

Jeff Boyce

Ken

Access has a New Object Toolbar button that you can use to start a query
wizard. One of the choice is an "unmatched" query. It sounds to me like
you want to find all the records in one table that are not in another table
.... an "unmatched" query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New Employees 2
Unable to add new records to a form 0
Electronic Payroll Stub 1
Need Records from 2 Tables 1
Find Breaks in Data Ranges - Follow-up 3
Auto Sum not working correctly 1
Update One Access Database from Another w/o Table Linking 1
Normalizing Tables and Enter Data in Fields Based on Employee Numb 1

Top