Noel Stratton wrote:
more thing that I can not figure out. I would like to sum all calculations created out of the "Total Amount Owed" field that was created.
Noel,Take a look at the WITH ROLLUP modifier of GROUP BY [1]. This is available since version 4.1.1.
Regards, Jigal. [1] http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
smime.p7s
Description: S/MIME Cryptographic Signature
