Hi, Paul
Almost everything can be done with VBA code in Access, but for this case, I think Pat is right, the design "each task ideally needs it's own table rather than have a table per team. " looks like a flaw, and then it leads to the problem you posted. So talking about why you choose that...