Andreas Saeger wrote:
Andreas Saeger wrote:
Download my database http://www.mediafire.com/?ydzh0thjzyy
Sorry I uploaded another version of that database collect2.odb
http://www.mediafire.com/?hdnnzivdnzi
Bah, how disgusting. The first was incomplete, the second belongs to a
bug report I filed today.
This is the third and only version of what I wanted to demonstrate:
http://www.mediafire.com/?mkmmnyytogy
The table named "Data" contains duplicates of Name-Value pairs.
"qryYearWeekNameValue" is suggested for the data pilot.
"qDupesInfo" shows info about duplicates.
"qDeleteDupes" lets you delete duplicates.
This should work with any fairly recent version of OOo with Java 1.5.x
or 1.6.x enabled in Tools>Options>Java.
Download, register the database and use the beamer to import spreadsheet
ranges and delete duplicate Name-Value pairs.
A database can be set up to reject any duplicates if you tell it to do
so by means of indices. Then you never need to search and destroy any
duplicates.
A dozend of people downloaded the wrong files.
My apologies for the inconvenience.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
