Hi all, sorry if OT. I have the following using case: Name, Surname , Job, Hobby, Pet, address John, Smith, NULL, photo, NULL, NULL John, Smith, student, NULL, cat, NULL by using name and surname as selecting key, I want : John, Smith, student, photo, cat, NULL that is I want to substitute the null valus of the LAST row with not-null value of previous one. how can I perform that ? in may installed vesion there aren't function as merge and collect. Thanks in advance GIU -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Entra in Mondolastminute, centinaia di offerte ti aspettano per le tue vacanze a prezzi lastminute! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6851&d=20070814 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
