Professional Web Applications Themes

30 day, 60 day, 90 day, subtract from Order Amount - Microsoft Access

On my Report I have these formulas below. The customer gets charged 2% over 30, 3% over 60 and 4% over 90 days. The date used is Order Date from orders table. I need now to calculate (Add) whatever amount is 0-30 days to the total Order Amount, or if the amount is 31-60 then add this amount or if the amount is 61-90 then add this amount. Lost as to how to do this. Thanks, Dave =Sum([Order Amount]) =Sum([0-30]) =Sum([0-60]) =Sum([0-90]) Grand Total =Sum([Order Amount])...

  1. #1

    Default 30 day, 60 day, 90 day, subtract from Order Amount

    On my Report I have these formulas below. The customer gets charged 2% over
    30, 3% over 60 and 4% over 90 days.
    The date used is Order Date from orders table. I need now to calculate (Add)
    whatever amount is 0-30 days to the total Order Amount, or if the
    amount is 31-60 then add this amount or if the amount is 61-90 then add this
    amount. Lost as to how to do this.

    Thanks,

    Dave



    =Sum([Order Amount])
    =Sum([0-30])
    =Sum([0-60])
    =Sum([0-90])

    Grand Total =Sum([Order Amount])


    Dave Guest

  2. #2

    Default Re: 30 day, 60 day, 90 day, subtract from Order Amount

    This is likely a value you need to store in your database. If, for example,
    I owe you $100 and go 30 days overdue, then I'll owe you $102. Let's say I
    then pay you the original $100 and you record that in your db ... if you
    haven't stored the amount of interest owed (the $2.00), then there's no way
    for the program to notify you that I still owe it.

    We call this "aging" although there are many different names for this.
    Basically, you step through all open orders, determining (a) how old it is,
    (b) how much is owed from the original balance (here, you can't charge
    interest on anything else). You then calculate the amount of interest owed
    and store this in a table, which includes the ID of the parent record (the
    "order" record). Then, your report would be based on (a) your "orders" table
    and (b) your "interest" table (along with any other tables required for your
    report). This can be performed at a set time each month, daily, etc etc
    based on the needs of your business or client.

    "Dave Elliott" <net> wrote in message
    news:Ukd5b.988$news.prodigy.com... 
    over 
    (Add) 
    this 


    Scott Guest

  3. #3

    Default Re: 30 day, 60 day, 90 day, subtract from Order Amount

    Dave - replies just posted in our original thread.

    --
    Ken Snell
    <MS ACCESS MVP>

    "Dave Elliott" <net> wrote in message
    news:Ukd5b.988$news.prodigy.com... 
    over 
    (Add) 
    this 


    Ken Guest

Similar Threads

  1. How to subtract in a calculation in Acrobat Pro 9
    By sander_wessel@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 9
    Last Post: March 26th, 09:07 AM
  2. subtract 3d objects
    By braddini in forum Macromedia Director 3D
    Replies: 2
    Last Post: May 29th, 09:24 PM
  3. Replies: 4
    Last Post: December 27th, 06:45 AM
  4. Unable to subtract pixels from a selection
    By vnative in forum Macromedia Fireworks
    Replies: 2
    Last Post: November 21st, 06:31 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139