Null Value in Query problem

[LJG]

Hi Guys,

How can I change this expression to add 0 to any null values?

soflinesum: Sum([qty]*[price])

TIA
Les

 

[Dale Fye]

soflinesum: Sum(NZ([qty],0)*NZ([price],0))

HTH
Dale

 

[LJG]

Cheers Dale,

Worked fine

soflinesum: Sum(NZ([qty],0)*NZ([price],0))

HTH
Dale

Hi Guys,

How can I change this expression to add 0 to any null values?

soflinesum: Sum([qty]*[price])

TIA
Les

 

[Dale Fye]

Glad I could help.

Cheers Dale,

Worked fine

soflinesum: Sum(NZ([qty],0)*NZ([price],0))

HTH
Dale

Hi Guys,

How can I change this expression to add 0 to any null values?

soflinesum: Sum([qty]*[price])

TIA
Les