C
Curtis Stevens
I have customers and affiliates I pay residuals on a monthly bases. This
query looks at all the accounts that have residuals that are due to the
affiliates. I want a criteria that would only display the affiliates that
have residual due where their residual is => $25. In other words, I may have
an affiliate come up that only has two accounts and the residual might add up
to $10.95 on all of their accounts. I don't want this to show up unless the
combine total I owe them is => $25.
When I open the query, it lists each account on a separate row with the
corresponding affiliate. So one affiliate may have 5 different rows
throughout the query (5 accounts that have residuals due). I want it to add
up those 5 that belong to that affiliate and if it is <$25, not to show them.
Screen Shot: www.gotmerchant.com/query.gif
Referring to screenshot:
Column A is the names of the affiliates. B is the customer's name they
referred. C is their percentage of profit they shall receive of column D
(column C X D = residual due).
Two ways you can do this. Add it up using column D, which I would simply
increase the required amount to equal to be $125 (20 % of column D ie $125 is
$25).
Or do this with column C in mind, using both columns, C & D to compute this
(preferred method).
Any guidance?
Thanks
Curtis
query looks at all the accounts that have residuals that are due to the
affiliates. I want a criteria that would only display the affiliates that
have residual due where their residual is => $25. In other words, I may have
an affiliate come up that only has two accounts and the residual might add up
to $10.95 on all of their accounts. I don't want this to show up unless the
combine total I owe them is => $25.
When I open the query, it lists each account on a separate row with the
corresponding affiliate. So one affiliate may have 5 different rows
throughout the query (5 accounts that have residuals due). I want it to add
up those 5 that belong to that affiliate and if it is <$25, not to show them.
Screen Shot: www.gotmerchant.com/query.gif
Referring to screenshot:
Column A is the names of the affiliates. B is the customer's name they
referred. C is their percentage of profit they shall receive of column D
(column C X D = residual due).
Two ways you can do this. Add it up using column D, which I would simply
increase the required amount to equal to be $125 (20 % of column D ie $125 is
$25).
Or do this with column C in mind, using both columns, C & D to compute this
(preferred method).
Any guidance?
Thanks
Curtis