Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    39

    Exclamation Unanswered: Help Please!!! Random Selections for Auditing

    You have all been a great deal of help before so I am hoping you can help me with this problem. I need to randomly select five accounts for each Reviewer in my database to be audited and record the audited date. Currently I have two tables which this query needs to be based off (only relevant information listed).

    tblAccountMatrixAccountInformation
    -----------------------------------------
    Business Unit
    Account
    Account Audited Date

    tblAccountMatrixOwnerInformation
    ----------------------------------------
    Business Unit
    Account
    Reviewer

    With the joins at Business Unit and Account,

    As I said I need to randomly select five accounts (Business Unit and Account combination) for each reviewer for accounts that have not yet been audited (Null values in Account Audited Date).

    I simply want to update tblAccountMatrixAccountInformation.Account Audited Date with the date the query was run and create/append an account audit selection table for the random accounts selected.

    Any help would be GREATLY appreciated!

    Thanks!!!

  2. #2
    Join Date
    Aug 2003
    Posts
    39
    No thoughts on this?

    Anyone....

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    see http://dbforums.com/showthread.php?threadid=872026 for a long discussion on a similar topic.

    izy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •