I made a query that goes directly to a form which pulls random results. I've been using RND(ABS([FIELD1])) or RND(NZ([FIELD1])) IN THE QUERY. Field1 refers to the actual unique product number. I sort the results by top five in the query to receive five random numbers every time.


Is the there a way to pull some numbers via a reoccurance value? Some numbers would appear more often than others. For instance, I made a reoccurance value field next to each unique number to determine what numbers will most likely appear.

.9 is more likely than .2 etc

I was wondering what code if any would be needed to figure this problem out.