Try using DLookup function.
Assumption: Team is a text field
INNER JOIN employees As emplT ON
SET samples.registrant =
If Team is a number field then change the DLookup to eliminate the text
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County