lundi 22 mai 2017

How to get a real 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. 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 as below.

Best regards for all.




Aucun commentaire:

Enregistrer un commentaire