How to track down doubloons in valentina ?

[olivier]

thank you Beatrix !

olivier

Le 30 sept. 04, à 11:59, Beatrix Willius a écrit :

> Please find below a quick example from Access:
>
> SELECT [PART_NUMBER], [Gross Value], [Phase Name]
> FROM [epsilon vpps]
> WHERE [PART_NUMBER] In (SELECT [PART_NUMBER] FROM [epsilon vpps] As Tmp
> GROUP BY [PART_NUMBER] HAVING Count(*)>1 )
> ORDER BY [PART_NUMBER];
>
> This query searches for duplicates in the Part_Number field and also 
> shows
> Gross Value and Phase Name. If I want to search for duplicates in
> something like First Name + Last Name, I would create a query with the
> concatenated fields in it and base the duplicate search on this query.
>
> Cannot check now, if this works in Valentina.
>
> HTH
>
>
> Mit freundlichen Gruessen
> Beatrix Willius
> Adam Opel AG
> CE Cost Reduction - Database-Team - IPC 33-01
> Tel.: ++49-6142-7-50694 Fax: ++49-6142-7-63383
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>