Append Without Duplicate Rows?

[terryzs]

Hi!

I need to append time log to time_log table.
I could append table without errors.
But if I append the second time it duplicates.
I cannot index Employee ID & Date coz there will be multiple entries.

Employee_ID, Date, IN, OUT

I need an append query which doesnt duplicate rows.

Thanks to all Access Programmers.

Regards,
Terry.

 

[statsman]

If you are using the append query to keep track of employee records (I assume this is used to create payroll among other things) you will have multiple occurences of the same Emplyee_ID, IN and OUT. There shold be only one date.
You will have to set the indexes of these fields to Duplicates OK.

 

[Pat Hartman]

You need a two-field primary key. The employee id and the date/time in. You can only log in once for the same date/time. Do not separate time from date. It is much easier to work with when they are together, especially if shifts span midnight.

 

[terryzs]

Yes I did

Hi!

Thanks for your suggestion I did it.

Will get back.

Regards,
Terry.