J
Jasper Recto
I have a query where I would like a colum that gives me the domain some for
a each group.
However, within that group there are duplicate lines that I don't want to
include in the sum.
Is it possible to do a DSum thats kind of like a Sum If in excel where it
will only sum if it meets a certain criteria?
For example,
Week Of: Order # Order Line Order qty Shipqty Shipdate
DSum
06/01/08 1000 1 50 10
6/2/08 70
06/01/08 1000 1 50 10
6/3/08 70
06/01/08 1000 1 50 30
6/4/08 70
06/01/08 2000 2 20 10
6/4/08 70
06/01/08 2000 2 20 10
6/4/08 70
In this scenario, the sum for week of 6/1 is the 50 and 20 from order 1000
and 2000. NOT the sum of all 5 lines.
Any ideas?
Thanks,
Jasper
a each group.
However, within that group there are duplicate lines that I don't want to
include in the sum.
Is it possible to do a DSum thats kind of like a Sum If in excel where it
will only sum if it meets a certain criteria?
For example,
Week Of: Order # Order Line Order qty Shipqty Shipdate
DSum
06/01/08 1000 1 50 10
6/2/08 70
06/01/08 1000 1 50 10
6/3/08 70
06/01/08 1000 1 50 30
6/4/08 70
06/01/08 2000 2 20 10
6/4/08 70
06/01/08 2000 2 20 10
6/4/08 70
In this scenario, the sum for week of 6/1 is the 50 and 20 from order 1000
and 2000. NOT the sum of all 5 lines.
Any ideas?
Thanks,
Jasper