>I have a dbf table of members and related info.
>How can I get a random sampling of 411 out of the existing 6812?
>I been trying to apply rand() but with no success..
>Thank you for your understanding.
I had to apply a similar process for the Quiz section. What I did was to select all the records in a cursor. Then, I use the _TALLY to RAND(). I can now use the RECNO() of the cursor to locate the records. I can't apply the RAND() on the original table as some records may be deleted.