can someone post a snippit on Summing tables together of a feild of the
entire Database ? why does everyone Have such a problem with this
question? everyone i ask says the same thing,, let me show what i'm
needing by Visual representation
MySQL database >> workorders
Table : Orders
Field(aa) ProjectName -- [enter Projectname]
Field [a] ElecprojCost ----- <-Enter in Number
Field [b] ElecprojBilling -----<-Enter in Number
Field [c] Elecprojremaining = [a] - [b]
Field [d] CtrlprojCost ----- <-Enter in Number
Field [e] CtrlprojBilling ----- <-Enter in
Number
Field [f] Ctrlprojremaining = [d] - [e]
Field [g] OtherprojCost ----- <-Enter in Number
Field [h] OtherprojBilling ----- <-Enter
in Number
Field [i] Otherprojremaining = [g] - [h]
Field [j] BondedAmount = <-Enter in Number
Field [k] Bondedprogbilling = <-Enter in Number
Field [l] Bondedprogremaining = <-= [j] - [ k ]
Field [m] totalelecworkonhand = <-sum of all remaining = (sum of C
all sum records for Values of (C)
Field [n] totalCtrlworkonhand = <-sum of all remaining = (sum of F
all sum records for Values of (F)
Field [o]totalOtherworkonhand = <-sum of all remaining = (sum of i
all sum records for Values of (i)
Field [p] totalworkonhand = m + n + o
Field [Q] totalBondedworkonhand = sum of all remaining = (sum of P
all sum records for Values of (P)
Any help in all this would be greatly appreaciated,, u can
also email me via [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
