S
steve goodrich
I use a query to select 5 random records from my db (1285 records in total)
the fields are, Id - first name - surname - dept
I enter Rnd([id]) in a blank field on my query, set the total to 5, set the
sort order asc and run the query.
Works great - every time I run the query I get 5 different members of
staff - which is exactly what I want.
This is used as a monthly draw to award staff a prize
The problem is, every time the database is closed and reopened, it picks the
exact same members of staff , as though in a loop - if the database is left
open it selects 5 different every time.
what am I doing wrong, and more to the point how can I prevent the same
selection being picked every time??
any help would be appreciated
Using Access 97
Steve
the fields are, Id - first name - surname - dept
I enter Rnd([id]) in a blank field on my query, set the total to 5, set the
sort order asc and run the query.
Works great - every time I run the query I get 5 different members of
staff - which is exactly what I want.
This is used as a monthly draw to award staff a prize
The problem is, every time the database is closed and reopened, it picks the
exact same members of staff , as though in a loop - if the database is left
open it selects 5 different every time.
what am I doing wrong, and more to the point how can I prevent the same
selection being picked every time??
any help would be appreciated
Using Access 97
Steve