It depends on what else you need in this specific report.
Having looked at your file, it's occurred to me for a while that you might want to add another table where you have exactly one record for each team where you store data unique to each team. relating this table to your other tables and performing a find might be one way to do what you want here...
PS. spend the weekend and yesterday alternating between sneezing and napping thanks to a brief but intense head cold.