Hi am sure this is simple can anyone show me how I can can a single row from each name in the following results:
Name Domain Open Open>7 Closed
Bjoern Diegmann IINFOSYS NULL 3 NULL
Bjoern Diegmann IINFOSYS 3 NULL NULL
Gareth Hoggins UK NULL NULL 5
Gareth Hoggins UK NULL 4 NULL
Gareth Hoggins UK 9 NULL NULL
i.e.
Name Domain Open Open>7 Closed
Bjoern Diegmann IINFOSYS 3 3 NULL
Gareth Hoggins UK 9 4 5
Any help greatly appreciated - James
Name Domain Open Open>7 Closed
Bjoern Diegmann IINFOSYS NULL 3 NULL
Bjoern Diegmann IINFOSYS 3 NULL NULL
Gareth Hoggins UK NULL NULL 5
Gareth Hoggins UK NULL 4 NULL
Gareth Hoggins UK 9 NULL NULL
i.e.
Name Domain Open Open>7 Closed
Bjoern Diegmann IINFOSYS 3 3 NULL
Gareth Hoggins UK 9 4 5
Any help greatly appreciated - James