Random records per group

[nschultz]

I would like to run a query in Access that selects 10 random records per group from a table.I have many different customers but their flight numbers are simalar. I want to select random 10 customers per flight number.

[Guest Dedo]

select COLUMNS from YOUR_TABLE_NAMEwhere mod(SOME_ID_OR_NUMBER_COLUMN, to_number(substr(to_char(sysdate,'ddmmyyyyHHMISS'), 13, 2))) = 0and rownum < 11 This work in ORACLE database. You can try in Access!

[nschultz]

Thanks but, I do not see how this can be used in Access. Any other help would be great. Thanks!