Random record search

[Benjix1991]

Hi all,

I have being reading on the internet looking for a solution but I've been unable to find any that help me.

I have a table called Awards with a PK named transNo. Part of my organisation's guidelines are that a manager would check 10% of these for compliance every month.



I had hoped to allow the user to enter the date range for the query (fairly easy as not defining causes access to prompt the user) which returns a random 10% subset for the manager to check.

I would also like to specify the office in which the manager operates so they aren't looking at other offices records. The awards table has a FK called custRef, to the customers table. The customer table includes a FK staffNo of the staff assigned to that customer to a Staff table and the Staff table has a FK names teamNo which links to the table Team wherein the staff's team's office number is saved.

I.e. (Awards.custRef = Customer.custRef) AND (Customer.staff = Staff.staffNo) AND (Staff.teamNo = Team.teamNo) AND (Team.officeNo = "O001") AND (dateAwarded >= [Start Date]) AND (dateAwarded <= [End Date])

Ideally this could be amended in VBA to define the office number based upon Current user.

I have had a load of bother doing this, any help would.be appreciated.

Thanks,
Ben

[orange]

See this sample in the repository section for ideas.