One record per date limitation

[WatsonDyar]

I have a form that supervisors use to input employee accountability for each day. Once supervisor completes the input, a command button is selected and records are appended to an archive table and then deleted from the "live" table. End of the month, reports pull from the archive table to tally absences.

The problem: when a supervisor submits the daily status report but resubmits the report do to an input error I now have two records for the one reported date.

How do I pull the end of month report without including an earlier record for a duplicate date? Is it possible to have access overwrite any records previously submitted for that day?

 

[Galaxiom]

The table needs a constraint to prevent two records for the same employee on the same date. If an attempt is made to write the second record and error will be thrown.

Google Composite Index Access for information on how to do it.

It would be possible to overwrite previous records by using an Update query rather than an Insert.

Earlier records would require some way to determine "earlier" as Access does not explicitly record the order records are entered.

 

[WatsonDyar]

This is definitely got me on the right track- thanks Galaxiom! Greatly appreciate the help!