turnerings database

Har sat flere point på.

If I get a bit of time later today I'll take a look at your question

Assuming you have the following tables/fields

tblHold
ID autonumber
HoldNavn Text

KampTabel
ID autoNumber
Hold1 Number (Relation to tblHOld.ID)
Hold2 Number (Relation to tblHOld.ID)
Hold1Maal Number
Hold2Maal Number




SELECT H.ID, H.HoldNavn, (SELECT count(*) FROM KampTabel K WHERE K![Hold1] = H![ID])+(SELECT count(*) FROM KampTabel K WHERE K![Hold2] = H![ID]) AS AntalKampe, (SELECT count(*) FROM KampTabel K WHERE K![Hold1] = H![ID]  AND K![Hold1Maal] >  K![Hold2Maal] )+(SELECT count(*) FROM KampTabel K WHERE K![Hold2] = H![ID]  AND K![Hold2Maal] >  K![Hold1Maal] ) AS VundeKampe, (SELECT count(*) FROM KampTabel K WHERE( K![Hold1] = H![ID]  OR K![Hold2] = H![ID]) AND K![Hold1Maal] =  K![Hold2Maal] ) AS Uafgjorte, (SELECT count(*) FROM KampTabel K WHERE K![Hold1] = H![ID]  AND K![Hold1Maal] <  K![Hold2Maal] )+(SELECT count(*) FROM KampTabel K WHERE K![Hold2] = H![ID]  AND K![Hold2Maal] <  K![Hold1Maal] ) AS TabtKampe
FROM tblHold AS H;

can you use this?

do you need further help here hestetoften?