sammentælling

lav en forespørgsel (i designvisning) hvor du tager feltet med 2x

1. hvor du Vælger "grupper efter"
2. hvor du vælger "Antal"

DCount("*", "mintabel", "mitfelt" = "korrekt")
DCount("*", "mintabel", "mitfelt" = "forkert")

For at få mulighed for at vælge mellem "grupper efter"/"Antal" mv.

Højreklikker du på feltet og vælger totaler

det er således at der til hver post er ca 30 felter som kan indeholde henholdsvis "forkert" og "korrekt". Hvordan tæller jeg sammen på tværs af felterne

it would be MUCH easier if your fields were True/false fields and then you could just add each value to get the total "korrekt" and "forkert"

Here is a query to sum up each row. In the example I have just used three columns you will need to do it for all columns and then change 3 to how many columns there are. Then when that is working you can make an agregate query to sum the rows.

SELECT IIf([fld1]="korrekt",1,0) AS f1, IIf([fld2]="korrekt",1,0) AS f2, IIf([fld3]="korrekt",1,0) AS f3, [f1]+[f2]+[f3] AS korrekt, 3-([f1]+[f2]+[f3]) AS forkert
FROM tblTest;

query to sum rows
SELECT Sum(qrySumColumns.korrekt) AS SumOfkorrekt, Sum(qrySumColumns.forkert) AS SumOfforkert
FROM qrySumColumns;

If I had a little more time I would do it in one query, sorry :o)

SELECT IIf([fld1]="korrekt",1,0) AS f1, IIf([fld2]="korrekt",1,0) AS f2, IIf([fld3]="korrekt",1,0) AS f3, [f1]+[f2]+[f3] AS korrekt, 3-([f1]+[f2]+[f3]) AS forkert, 100/3*[korrekt] AS pct
FROM tblTest;

bukse do you have any comments?

bukse>please respond to this so we can get this question closed!

thanks :o)