Best way to combine records? 3

[perrymans]

I have:

   A     |    B   |   C   |   D    |    E     | F
---------|--------|-------|--------|----------|-----
V0002420 | DG0010 | Desc. |        |          |
V0002420 | DG0010 |       | Status |          |
V0002420 | DG0010 |       |        | Severity |
V0002420 | DG0010 |       |        |          | Cat.

How can I make it:

   A     |    B   |   C   |   D    |    E     | F
---------|--------|-------|--------|----------|-----
V0002420 | DG0010 | Desc. | Status | Severity | Cat.

I am looking for the best and easiest way. There are multiple sets like this and it is the end of an automated routine anway, so it will be fired from VBA.

Thanks. Sean.

 

[Remou]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

 

[Golom]

Select A, B, MAX(C) As MC, MAX(D) As MD, 
       MAX(E) As ME, MAX(F) As MF INTO myNewTable

From myTable

GROUP BY A, B

 

[perrymans]

I think I will go with the easier SQL version by Golom.

Thank you both! Sean.