Create a randomly generated list with 1 from each strata

[Amberman]

Hi all

I am a bit stuck on this one. I have a filtered table of sporting events with dates and times. I have also manually allocated intervals to the events so that there is at least 3 hours between intervals (so I am only betting on one sporting event at a time an my accumulator bet)

Table columns are:

Interval | Date | Start Time | Event | Price

Im trying to create Xn combinations of events randomly to measure the combined price of the 5 fold or 6 fold bet, with no more than one event from each period, sorted by date, then time.

Im not at all sure how to do this. Any help would be appreciated.

Thanks in advance

Amberman