adding up a whole colum to give a total number

KeviJay · May 28th, 2008, 12:42 PM

Hey folks,
I'm trying to add a whole colum of wages together to give me the total wage bill in a sql statement is this possible if so does anyone have any ideas where to start

BrianWren · May 28th, 2008, 01:37 PM

Code:

SELECT DSUM(<ColumnName>)
FROM   <TableName>

(Access)

Code:

SELECT SUM(<ColumnName>)
FROM   <TableName>

(Oracle)

KeviJay · May 29th, 2008, 08:15 AM

Thanks Brian you how many simple things i tried. Feelin pretty stupid now though.Agian m8 thanks for reply to this and many other posts ur a wee star m8 cheers