Brian,

>can someone post a snippit on Summing tables together of a feild of the
>entire Database ?

Do you mean summing all row values of a column in a table, grouped by the value of another column? If so, for example to retrieve all electprojcost, electprojbilling values and their differences per projectname would be ...

SELECT
  projectname,
  SUM(electprojcost),
  SUM(elecprojbilling),
  SUM(elexprojcost-electprojbilling) AS margin
FROM orders
GROUP BY projectname;

Or do you mean something else?

PB

-----

Brian E Boothe wrote:
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  subrian@mtcnet.net