Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    20

    Unanswered: subtract two fields

    I have a sum in my sql statement select sum(service.price) as total and sum(service.price) *.10 as savings To give a 10% discount

    when i write response.write rs("total") or rs("savings") the right info displays
    But i need to subtract savings from total. how would this be written

    i.e. response.write rs("savings - total")

  2. #2
    Join Date
    May 2006
    Posts
    20
    nevermind i was able to do the match in the sql statment

Posting Permissions

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