nice

• • Reply

  17 years ago

  by phracker76

  Luke Lesurf

  London, England, United Kingdom

  Joined 18 years ago

  Break your calculations down abit.
  

  
  First work out UnitPrice * Qty
  

  
  Then find 1 percent of that
  

  
  times the 1 percent by 17.5
  

  
  add that to unitprice*qty
  

  
  work out 1 percent of total
  

  
  times the 1 percent of total * 5
  

  
  minus this from the total (your discount)
  

  
  

  Report abuse
• • Reply

  17 years ago

  by phracker76

  Luke Lesurf

  London, England, United Kingdom

  Joined 18 years ago

  you can do it anyway you like, i write invoice processing system for a living so validation rules on totals and line level caculations are a dialy thing for me. Thats my suggestion. dates can be compared like anything else
  

  
  

  
  if format(now,"DD/MM/YYYY") = format(inputdate,"DD/MM/YYYY") then
  

  
  bla bla bla

  Report abuse
• • Reply

  17 years ago

  by krunal

  Krunal Acharya

  , India

  Joined 17 years ago

  nice

  Report abuse