Checkbox Count

[hinchi1]

Just to archive records that are complete

[ssanfu]

I would have the extra field to indicate if the record is archived or not. For the Desk Allocation List (in Post #1) would be filtered to show the not archived records.
Then it is just an update query or just edit the records.

If you wanted to print a history of a specific desk usage, you could easily query for all records for a specific desk number.
If the records are in two tables it is a little harder.

[hinchi1]

I will look in the morning and thanks again, much appreciated.