remove duplicate

[sal21]

In attached sheet the structure of my Table1.
I need with a Sql (VB6 and ADO) to remove duplicate based PROGRESS.
How to?

Note:
in old the actually data in new wath i need.

[HansV]

Would it be OK to create a new table?

[sal21]

Would it be OK to create a new table?

If is necessary yes, sure!

note:
original Table is named SERVIZIO

[HansV]

Try

SELECT Max(SERVIZIO.DATA_MAIL) AS DATA_MAIL, SERVIZIO.PROGRESS, Max(SERVIZIO.DRICEZ) AS DRICEZ, Max(SERVIZIO.HRICEZ) AS HRICEZ, Max(SERVIZIO.OI) AS OI, Max(SERVIZIO.NOM) AS NOM, Max(SERVIZIO.SOLL) AS SOLL, Max(SERVIZIO.N) AS N, Max(SERVIZIO.CASO) AS CASO INTO SERVIZIO2 FROM SERVIZIO GROUP BY SERVIZIO.PROGRESS

This will create a new table named SERVIZIO2.

[sal21]

Try

SELECT Max(SERVIZIO.DATA_MAIL) AS DATA_MAIL, SERVIZIO.PROGRESS, Max(SERVIZIO.DRICEZ) AS DRICEZ, Max(SERVIZIO.HRICEZ) AS HRICEZ, Max(SERVIZIO.OI) AS OI, Max(SERVIZIO.NOM) AS NOM, Max(SERVIZIO.SOLL) AS SOLL, Max(SERVIZIO.N) AS N, Max(SERVIZIO.CASO) AS CASO INTO SERVIZIO2 FROM SERVIZIO GROUP BY SERVIZIO.PROGRESS

This will create a new table named SERVIZIO2.

sorry for delay, work perfect!

note:
but wathch wath i see in body of email(for admin of longue)...(&#)

SELECT Max(SERVIZIO.DATA_MAIL) AS DATA_MAIL, SERVIZIO.PROGRESS, Max(SERVIZIO.DRICEZ) AS DRICEZ, Max(SERVIZIO.HRICEZ) AS HRICEZ, Max(SERVIZIO.OI) AS OI, Max(SERVIZIO.NOM) AS NOM, Max(SERVIZIO.SOLL) AS SOLL, Max(SERVIZIO.N) AS N, Max(SERVIZIO.CASO) AS CASO INTO SERVIZIO2 FROM SERVIZIO GROUP BY SERVIZIO.PROGRESS

[HansV]

The email apparently converts the parentheses ( and ) to character codes. I don't think we can avoid that. So it's always best to visit the forum when you receive an e-mail notification.

[sal21]

The email apparently converts the parentheses ( and ) to character codes. I don't think we can avoid that. So it's always best to visit the forum when you receive an e-mail notification.

OK!