re: Any Microsoft Access Experts?

Your design is the problem I think. See the long post aboout 2 above. You need an alumni table, a team table, a competition table, and then a "results" table to store the combinations. So my alumni Id, team Id, and competition id would be stored.So if I'm A,on team B, inn competition C the results table would store ABC in a row (separate columns). Then if I'm on team B, but in competition D it would store ABD.