Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2008
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Table with following fields:

    date
    buyer
    merchant
    amount
    limit

    A buyer has a transaction limit per merchant. Management wants to be able to check if a buyer is "splitting" transactions to avoid the limit. For example if a buyer has a $1,000 limit per transaction the buyer may have the merchant ring up a $1,500 transaction by splitting it to two $750 transactions. Mgmt wants to check for multiple transactions by the same buyer with the same merchant within a certain number of days (for exampe 3 days) which exceed that buyer's limit. Those transactions would then be subject to additional review.

    I anticipate I will need to write a procedure in Visual Basic to do this but thought I 'd check to see if anyone had any other suggestions on how to approach this.

    Thanks,

    Texas TJ

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can create a query to find such transactions. I have attached a zipped sample database with a small table tblTransactions and a query qrySplitTransactions. The query uses DSum to total all amounts for a buyer within 3 days after a transaction, and selects records for which the total is over the limit.

    The date returned by the query is the first transaction date in the series that produces a total over the limit.

    If there are many small transactions in a short period of time, the query may flag more than one date within the same series.
    Attached Files Attached Files

Posting Permissions

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