here is sample data;

1Nicholas Edet802009-12-22 00:00:00.000

2Nicholas Edet952009-12-22 00:00:00.000

3Nicholas Edet902009-12-22 00:00:00.000

4Emanuella Edet762009-12-22 00:00:00.000

5Emanuella Edet802009-12-22 00:00:00.000

6Emanuella Edet972009-12-22 00:00:00.000

7Emanuella Edet762009-12-20 00:00:00.000

8Nicholas Edet952009-12-20 00:00:00.000

9jackson Devo702009-12-21 00:00:00.000

10Sarah Palin792009-12-21 00:00:00.000

then i want the results to be like this with all the columns included;

jackson Devo70

Emanuella Edet82

Nicholas Edet90

Sarah Palin79

any help is welcome and i appreciate it guys thank you