An other thing I am doing once a week is:. Select Invoice_id reg_nr transp_nr Count(transp_nr) from myview where ??? group by Invoice_id reg_nr transp_nr
Where in my case Invoice_id reg_nr transp_nr stands for Invoicenumber, vehicle_registration_number and slip_of_transportation. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 S-131 30 NACKA SWEDEN +46 070 545 50 38 [EMAIL PROTECTED] -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För John Docherty Skickat: den 18 mars 2008 11:05 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Unique Values I was wondering if there is a quick way of determining if all rows in a selection have a distinct value, the column in question being a text field. Any suggestions (or the obvious answer which I cannot think of), would be much appreciated. Thank you. Regards, John Docherty
