At every cycling race, there is a lucky draw afterwards based on the cyclist racenumber for that race.(race numbers may change from race to race per person)
I need to create a lucky number generator on a form, where you press a button, and a race number is selected randomly from this current race, and appears on the screen.
My table is called "RaceEntry" and the racenumber field (used in lucky draw) is called "RaceNo".
I will probably have to use a query to filter this table based on a "racedate" in order to get only lucky numbers from a specific race.
The numbers are usually from 1 to 1500 but may vary from race to race.
Any suggestions?