Hi!

I'm trying to solve the following... (In FB1.5 RC7)

Having a table with the columns:
dlink regdate worker wtype artno pcs nett gross
12345 12/11/2003 MS 1 xxxx 2.5 150 195
12345 12/11/2003 MS 1 yyyy 1.0 75 105
12345 12/11/2003 MS 1 yyyy 4.0 11 23
12345 13/11/2003 MS 2 xxxx 0.7 150 195
12345 13/11/2003 MS 2 yyyy 2.3 375 525
12351 13/11/2003 MS 1 xxxx 0.7 150 195
12351 13/11/2003 MS 1 yyyy 2.3 375 525

What I need out of this is a resultset grouped on dlink, regdate,
worker and wtype.
Each row should contain sum_of_xxxx(nett*pcs), sum_of_xxxx(gross*pcs),
sum_of_yyyy(nett*pcs), sum_of_yyyy(gross*pcs).

Resulting in
12345, 12/11/2003, MS, 1, xxxx nett, xxxx gross, yyyy nett, yyyy gross
12345, 13/11/2003, MS, 2, xxxx nett, xxxx gross, yyyy nett, yyyy gross
12351, 13/11/2003, MS, 1, xxxx nett, xxxx gross, yyyy nett, yyyy gross
as a result of the query.

Is this possible to achive? Or am I completely out of my mind? :-)

Any help or ideas would be very much apreciated.

Cheers
/Johan