group by .....?

C

chill

hello , can anybody help me on this....
i have the following query...

SELECT A.A1,A.A2,A.A3,A.A4, B.B1, B.B2, B.B3, B.B3, B.B4, B.B5, B.B6, B.B6,
C.C1,C.C2,D.D1,D.D2,D.D3,D.D4,D.D5,D.D6,D.D7,(D3+D4+D5+D6-D7) AS
TOTALperRecord
FROM A INNER JOIN (B LEFT JOIN (C LEFT JOIN D ON C.C1 = D.D1) ON B.B1 =
C.C2) ON A.A1 = B.B2
HAVING (((B.B3]) Between #1/1/2007# And Date()) AND ((B.B4)=No) AND
C.C2)=No) AND ((C.C1)=Yes))
ORDER BY A.A1;


im using A,B,C,D because they r in greeks characters...

the D's values r currency. i want to group the *totalPerRecord* euro value
from the forth table per B1 value which is an autonumberID in my second table.
Thanks
 
Top