Timeclock clearing

hi Willie, you can do so and there are many ways to do so. I am writing below one way and describing for the 2nd as optional to you.

go to SO Administrator, and Connect to database, then click on Query and Click New write this first

SELECT * FROM TIMECLOCK where TimeIn>'2007-01-01' and Timein'2007-01-01' and Timein is there a way to purge data entries in the time clock? I now have years of

Akber, is there a way to delete a specific cashiers time clock entries. I have an employee that does not work for me anymore and I have to sort through all those entries to get to valid entries. Craig

In store administrator do a query

SELECT Cashier.ID, Cashier.Number, Cashier.Name, Timeclock.* FROM Timeclock INNER JOIN Cashier ON Timeclock.CashierID = Cashier.ID WHERE Cashier.Number = 26

Replace the Cashier.Number above with the number of the cashier who's records you wish to review

Once you have confirmed the records are the correct ones you wish to delete run the following query

DELETE FROM Timeclock FROM Timeclock INNER JOIN Cashier ON Timeclock.CashierID = Cashier.ID WHERE Cashier.Number = 26

Replace the Cashier.Number above with the number of the cashier who's records you wish to delete

Thanks!