Not Adding Up

[LaCour]

In the select statment, I am trying to add up multiple fields and alias their sum as a new field.

Here is a shorter simple example of my ugly fields names:

Select (projects.[field1]+projects.[field2]+projects.[field3]) AS [A Sum]
From projects

The field "A Sum" is coming back blank. Any suggestions?

FYI: I am not trying to do an agregate sum here ... I am trying to

Thanks
Blair

 

[SkipVought]

Select (projects.[field1]+projects.[field2]+projects.[field3]) AS 'A Sum'
From projects

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[r937]

... AS [A Sum] is correct

i bet one of the values is null



try this:

select nz([field1],0)
     + nz([field2],0)
     + nz([field3],0) as [A non-null sum]
  from projects

rudy

http://r937.com/

SQL Consulting

 

[LaCour]

It was the Nulls - thanks