Hi,

thanks I understand. This query runs perfectly for me in SQL server.

I tried it also in MS Access, but it have problems with the "SELECT *, rn =ROW_NUMBER() OVER(PARTITION BY...

Hi,

thanks for the answers. But I think I didn't explain my question not good enough.

The table contains about 30000 lines. So I think I cannot make my query with the...