vendredi 24 juillet 2015

MS Access - select one random record for each unique value in a column

I have a table of ~3,000 invoices that are from 40 different vendors. In MS Access 2013, how would I randomly pick one record from each of the 40 vendors?




Aucun commentaire:

Enregistrer un commentaire