General discussion

Locked

Random Selection via Access with no duplications

By l8poulse ·
Hello, I'm relatively new user to Access and I'm running into a block regarding random sampling. I'm building a database for auditing purposes and I need to pull a random selection from 453 main cases,and each main case has 5 or more sub cases. I have to ensure I pull one sub case from each main case once per quarter.

I was able to build a query to run a random sample from the entire sample of sub cases, now I just need to be more specific. Here's how my table & query are designed.

SQL:

SELECT TOP 8 cb_listing.ID, bc_listing.rom, cb_listing.region, cb_listing.[bc#], cb_listing.bcname, cb_listing.[cb#], cb_listing.desc, Rnd([ID]) AS RandomValue
FROM cb_listing INNER JOIN bc_listing ON cb_listing.[bc#]=bc_listing.[bc#]
ORDER BY Rnd([ID]);

Query:

ID
ROM (name of person)
Region
BC# (main case)
BCName
CB# (sub case)
Description
RandomValue: Rnd([ID])


I don't know if this can be done but would appreciate any help you can bring!

Lauren

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums