Results 1 to 2 of 2
2009-08-19, 05:02 #1
- Join Date
- Dec 2008
- Thanked 0 Times in 0 Posts
Table with following fields:
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.
2009-08-19, 06:27 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.