DAO / Regne ud totalsum

I suggest that you make a query in Access and then use this in your VB program

your SQL will look somnething like this
SELECT tblKunde.KundeID, tblKunde.KundeNavn, tblKunde.Adresse, Sum([varePris]*[tall]) AS Expr1
FROM tblKunde INNER JOIN tblBetaling ON tblKunde.KundeID = tblBetaling.KundeID
GROUP BY tblKunde.KundeID, tblKunde.KundeNavn, tblKunde.Adresse;

Thank You Terry,
Det nærmeste jeg kome til er:
SELECT [tblKunde].[KundeID], [tblKunde].[KundeNavn], [tblKunde].[Adresse], ([varePris]*[tall]) AS Expr1
FROM tblKunde INNER JOIN tblBetaling ON [tblKunde].[KundeID]=[tblBetaling].[KundeID]
WHERE [tblBetaling].[KundeID]=1;
Men jeg kan ikke sumere alle Expr1 felter, med: Sum([varePris]*[tall]) AS Expr1 bliver den gry forkert.

gry=strSQL :)

Does the SQL I gave 08/01-2006 19:24:45 not work? Can you give an example of the data nad what you expect from SQL. Even better, if you can maybe send me your dB!

eksperten@NOSPAMsanthell.dk
remove NOSPAM

If Not rs.EOF Then
    rs.MoveFirst
    Do While Not rs.EOF
        TempTotal = TempTotal + rs!Expr1
        rs.MoveNext
    Loop
End If

Gjør arbeid uten SUM()
MVH Terra

Great :o)

TempTotal = DSum("expr1", "YourQuery")

might work too

replace YourQuery with then ame of the query

status terra?

Terry -> DSum bliver forkert, jeg bruger:
Svar: terra 09/01-2006 18:38:18 og den virker. Dine kommentarer var lidt tankevekende og var til hjælp for at bringe mig på ret vej og jeg vil si tak for det.
Fifty/Fifty Terry? MVH Terra

fifty/fifty sounds fine Terra :o)

but I'm sure it shouldn be necessary to do it in code, none the less you have it working and thats what counts

tak, og god aften