C
Craig
Hello all,
I have found some great info posted on random selection, but have not been
able to find anything to help with all parts of my intended application. I
have to put together a query to perform a random selection of customer files
for review.
I have four variables in tblTransactions: Customer, Assigned Rep, Rep
Status, and Last Transaction. I have to pick a random 20% sample of
customers who conducted at least one transaction within the specified date
range (this much I have been able to achieve through previously posted
info.). The twist is that for Rep Status=Managing Rep, and a given Managing
Rep is the Assigned Rep for >= 20% of the records with activity in the given
time period, I have to pull an additional 10% of that Managing Reps customer
files.
I am sure (relatively so at least) that this can't all be done in one query,
but I am not sure how to create a second query for the additional 10% that
excludes all records already in the first random selection.
If I have not been clear about any of this, please ask for clarification.
Thank you in advance for being smarter than me!
I have found some great info posted on random selection, but have not been
able to find anything to help with all parts of my intended application. I
have to put together a query to perform a random selection of customer files
for review.
I have four variables in tblTransactions: Customer, Assigned Rep, Rep
Status, and Last Transaction. I have to pick a random 20% sample of
customers who conducted at least one transaction within the specified date
range (this much I have been able to achieve through previously posted
info.). The twist is that for Rep Status=Managing Rep, and a given Managing
Rep is the Assigned Rep for >= 20% of the records with activity in the given
time period, I have to pull an additional 10% of that Managing Reps customer
files.
I am sure (relatively so at least) that this can't all be done in one query,
but I am not sure how to create a second query for the additional 10% that
excludes all records already in the first random selection.
If I have not been clear about any of this, please ask for clarification.
Thank you in advance for being smarter than me!