Hi All,

I'm using the following query to select records in a database:

SELECT (consumpties.prijs*aantallen.aantal) AS subtotaal, * FROM Leden INNER
JOIN (Consumpties INNER JOIN Aantallen ON Consumpties.Id =
Aantallen.consumptie) ON Leden.id = Aantallen.Leden WHERE Aantallen.Leden="
& naam_id & " ORDER BY consumpties.soort, consumpties.naam

The field subtotaal is created by multiplying two fields with each other.
Now I want to add all values in this subtotaal field, but I don't know how.
I know I have to use the sum() thingy, but I don't know how I should build
it into the query I made.
Please, can anybody help me?

with regards,
Pascal Herms

Hi,

I found out how to do it.
I just made another query. The same as mentioned below, but without the
order clause.
It works perfect. It might not be the most correct way, but hey, it works.

greetings,
Pascal

"Pascal Herms" <pherms (AT) planet (DOT) nl> schreef in bericht
news:bk03bp$k77$1 (AT) reader10 (DOT) wxs.nl...