New Employees

[KenP]

I have payroll every two weeks. To process the new payroll I download an
excel spreadsheet of the current payroll information into a new table in
Access. I need to know how to use the last payroll data and the current
payroll data to determine if I have any new employees. Meaning a new employee
would show up in current payroll data but not last payroll data.

Any help would be greatly appreciated.

 

[Public]

Use the unmatched query wizard to create the query for you.
In the query tab, click on new, choose "unmatched" from the list of options.

 

[Rick B]

Without knowing your data structure, it would be very difficult to answer
this question. I would assume you have a table of employee information, and
a table that contains hours worked? I assume that you import the hours
worked to a new or existing table every two weeks? Assuming this excel file
includes and "employee number", you could simply run an unmatched query to
locate all "hours" records that do not have a matching entry in your
"employees" table.

Again, we'd need to know more about your data before we could give you an
complete and accurate answer.