Recent content by perrygascoine

That worked a treat - thanks. I do have one other query.... I want to list the teams and show the games they have played. For example Chelsea Liverpool Man Utd Arsenal Liverpool Chelsea Everton Spurs The teams would come out of the teams table and the fixtures from the games table...

I am really sorry but access is not my speciality. I can do simple queries but get confused with outer joins etc. Could you please explain what I need to do

I have a table called team which contains the following fields... team_id [autonumber] team [text] There are 46 teams each with their own team_id. I have a table called games and in this table there are many fields. Two of the fields are called Home_id [number] and Away_id [number] which...