Search results

Oh wow. There's a whole load of functions I've never seen before! So instead of using a sub-select to return the other team's score, it looks like I can just use DLookUp to do the same job? Light-bulbs are going on in my head.... That's magic, I'll give it a go! Cheers Leigh mate. Dan

Many thanks for your replies (Adam's was particularly helpful :rolleyes:). Naturally I've already had a look for solutions elsewhere but I'm still not clear about what the problem is. Here is my SQL: UPDATE MatchTeams SET MatchTeams.Points = IIf([MatchTeams].[Score]=(SELECT Dupe1.Score FROM...

I have a table of results from soccer matches (MatchTeams) where each record represents a team in a match and the number of goals they scored. In other words, there are two records for each soccer match, one for the home team and one for the away team (the primary key is a MatchTeamID field)...