Need help

[Darko1234]

So i'm new to ACCESS and have to do football league and i have a problem with Leage standings.

SELECT Tekma.Domači AS IDEkipe, IIf(Tekma!Ekipa1>Tekma!Ekipa2,3,IIf(Tekma!Ekipa1=Tekma!Ekipa2,1,0)) AS Točke, Tekma.Ekipa1 AS Dosezeni, Tekma.Ekipa2 AS Prejeti, Tekma.Krog
FROM Tekma
UNION SELECT Tekma.Gost AS IDEkipe , IIf(Tekma!Ekipa1<Tekma!Ekipa2,3,IIf(Tekma!Ekipa1=Tekma!Ekipa2,1,0)) AS Točke, Tekma.Ekipa2 AS Dosezeni, Tekma.Ekipa1 AS Prejeti, Tekma.Krog
FROM Tekma;

So i want to sum points for each team, but the program does it like in the picture i will attach below.
After every game points do not add up, instead same team is created and points are given to that team.


Did i do soemthing worng?

[Darko1234]

Solved it myself

[pbaldy]

Thanks for updating the thread and welcome to the site by the way!

Posting your solution could help someone else.