lundi 22 mai 2017

How to get new random rows every time from an MS-Access query?

This is a problem I faced As I have a large database of meteorological data, I want to get random rows to manipulate through a model. I used a column with a random number in the ORDER BY statement. Here are my trials and their drawbacks:

1- I tried to use a column with rnd() function. It returns the same number for all records!

2- I combined the row number with the random function as: rnd([ID]). It returns a new number for each record, but the whole set of numbers is repeated every time!

3- Finally, I found the answer that I want to share with you.

Best regards for all.




Aucun commentaire:

Enregistrer un commentaire