I have a query with a calculated (double) field with the following equation:
Random Number: Rnd([Person ID]+(Now()*100000-Int(Now()*100000)))
the idea being that the random seed is regenerated by utilizing the Person ID as a new seed + the now function.
this works and fills the field with random double numbers.
I sorted in the query grid, however its clear that it doesnt sort by value in any direction and I am not sure why.
I tried another way following a suggestion from the forum and did this in VBA but Microsoft showed a way using the query grid which seemed simpler and still returned a random number per row.
Advice would be much appreciated as to why its wont sort, if it did it would return the rows randomly by selecting the top x rows that I want.
Regards
Peter
Random Number: Rnd([Person ID]+(Now()*100000-Int(Now()*100000)))
the idea being that the random seed is regenerated by utilizing the Person ID as a new seed + the now function.
this works and fills the field with random double numbers.
I sorted in the query grid, however its clear that it doesnt sort by value in any direction and I am not sure why.
I tried another way following a suggestion from the forum and did this in VBA but Microsoft showed a way using the query grid which seemed simpler and still returned a random number per row.
Advice would be much appreciated as to why its wont sort, if it did it would return the rows randomly by selecting the top x rows that I want.
Regards
Peter
