Assign the items the same random number in the 1st field and then use a
second field for the order 1,2,3,.... Then sort on the two fields.
Items that are singular just keep the 2nd field empty.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=168766

Microsoft Office Help