Results 1 to 1 of 1
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Jacksonville,NC, USA
    Thanked 0 Times in 0 Posts

    Query quandry (Access 2000)

    I wonder if this day will ever be over...sigh Will try to make this the last one I ask today, seriously...adding a pic of query

    If I have a query that looks at when a payment was made, counts the days between that and the day it was shipped...if over 30then considered late and customer must pay 1% late fee on that amount...But how can I tell it once month two comes that the customer has made another payment, as this is written in the same field as the previous payment, and that they only owe 1% late fee if they made that payment after the 15th of the month.

    Right now my formula looks like this:

    1%LateFee: IIf([Daystween]>=30,CCur([APR18%]*1.01))

    The APR is figured like this:

    APR18%: IIf([Paid]=0,CCur([Balance]*1.018))

    where Paid is a check box determining if they paid in full yet or not

    where they already owe 18% monthly on account balance just for having a balance, the 1% is in addition to that if they are paying after the 15th of every month.

    Just can't figure out how to tell the formula to look at the payment date and if it falls after the 15th then to charge the flat rate late fee of 1%


    Attached Images Attached Images
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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