Null Value problem in query

  • Thread starter Thread starter LJG
  • Start date Start date
L

LJG

Hi Guys,

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

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

TIA
Les
 
LJG said:
How can I change this expression to add 0 to any null values?

soflinesum: Sum([qty]*[price])
Click to expand...


You should not have to do that because the aggregate
functions ignore null values in their calculations.
 
Back
Top