Hello.

I think I know the answer to this, but is it possible using SQL to sum a number of columns in each row to a Totals column?

At present I'm skipping through the resords to do it.

Thanks.

Rob


Assuming you know which columns you want it should be possible something like

select _Sequence, _Order, (_Sequence +_Order) AS CrossTotal from billing

or to give the totals

select SUM(_Sequence), SUM(_Order), SUM((_Sequence +_Order)) AS CrossTotal from billing


Roy Lambert [Team Elevate]