Randomise a selected group of rows

[Reno_04]

I have a table (tbl_entry) of performers and the different sections they are performing in. I can pull the performers for each individual section but is it possible to then give the performers a random number that will indicate the order in which each will perform. Eg:
5 performers in section 21a

Molly
Mary
Mike
Merv
Mandy

So can I get access to randomly assign numbers 1-5

Thx for your help in advance

 

[John Big Booty]

Welcome to the forum.

I think you should find that this article explains how to do what you are after.