Query needed please help urgent

[vasu1211]

Original Table
ozip dzip shipdate wgt Transport cost

A B 12/1/07 20 450
C D 4/1/08 15 890
E F 9/1/08 78 750
A B 12/1/07 42 789
X Y 1/1/08 17 900
C D 4/1/08 34 90

Needed Output

ozip dzip shipdate wgt Transport cost

A B 12/1/07 20 450
A B 12/1/07 42 789
E F 9/1/08 78 750

I need to create a query which extracts rows with wgt >60 and also WHEN the fields ozip, dzip and shipdate are same, the query should add the wgts and then sum of wgts should be >60- for example the first and fifth rows should be extracted since sum is 62.

I have attached the output that is required for the above example. please help

 

[ajetrumpet]

I need to create a query which extracts rows with wgt >60 and also WHEN the fields ozip, dzip and shipdate are same, the query should add the wgts and then sum of wgts should be >60

I would say something like this might work:

SELECT ozip, dzip, shipdate, sum(wgt)

FROM yourTable

GROUP BY ozip, dzip, shipdate

HAVING sum([wgt]) > 60;

Check this out too:

http://www.access-programmers.co.uk/forums/showthread.php?t=135763