Hi all, well i have run into another problem - I have the year on year enrollment info for a largish number of students 10000+ However, there are a number of duplicates - continuing students studying over a number of years. I have had a colleague separate out the duplicates using MSAccess queries - but this is a lot of work and means importing and exporting between packages and is not exactly satisfactory in terms of results.

What i would like to do is to be able to draw a random sample from the data using Select Cases - to send out questionnaires - but obviously i dont want duplicates appearing in my random sample any ideas for cleaning up the data? but in a way that still identifies students as enrolling in more than one year ?

ADVthanksANCE

Muir Houston Research Assistant Centre for Continuing Education University of Paisley

Legal disclaimer --------------------------

The information transmitted is the property of the University of Paisley and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination and other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.

--------------------------