i have this competition and at the end of the day i ant to get a winner from all the day's records of people whoe called for the competition.

I want to enter all the records for the day and then at the end of the day when i click this button, i want access to find a random winner for me .

The thing is that i want to count the number of records returned after i peform a date query on them to fing all entrants for the day and then from that i want a winner.

Is there any way i can count the number of records returned after a query and then use that number to define my max number of random function and then output the record that corresponds with that winner?

Can someone help please

Could you create a calculation field in the query and have it use Count? There's a VB command to count records in a returned data set though, that may be better.

regards,
darcybaston@mac.com