Query Question

[serino]

Hi everyone,

I have query which pulls information from table that contains the following fields jobnumber, phase1, phase2, phase3 and phase4.

The query displays the information in the following way.

JobNumber Phase1 Phase3 Phase3 Phase4
302012 1
302012 2
302012 3
302012 4
304433 1
304433 2

Is there a way I can combine the jobnumber field to display only one row per jobnumber?

JobNumber Phase1 Phase3 Phase3 Phase4
302012 1 2 3 4
304433 1 2


Any suggestions?

 

[PHV]

A starting point (SQL code):
SELECT JobNumber, Sum(Phase1), Sum(Phase2), Sum(Phase3), Sum(Phase4)
FROM yourTable GROUP BY JobNumber

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[serino]

Thank You PHV. Thats exactly what I needed to accomplish.

As always your great help!