number of records returned from access queries

[pankajeshwara]

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

 

[darcybaston]

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