Recent content by chrismc10

Thank you all. After going through the replies and looking at my options vs. the desires of the folks in charge, what I did was created a query for each rank that pulls 1 random member and places him/her into an export table (will be used to generate the xls file). Then I have a delete query...

Good day I created a system to randomly select jury members from several assigned military units (This is a project I am working for a branch of the military.) What I am currently doing is having the database create a random number using the RND function, then I am having a query pull the top 4...