Null Value in Query problem

L

LJG

Hi Guys,

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

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

TIA
Les
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Null Value problem in query 2
“Division by zero†3
System Resource Exceeded/Query Too Complex 4
Adding the value of two fields when value is null 4
Query: Calculating 2
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
SQL query 4
Nz or Iif 8

Top