Null Value problem in query

L

LJG

Hi Guys,

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

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

TIA
Les
 
M

Marshall Barton

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.
 

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 in Query problem 3
Switch Function w/nested IIf Functions 1
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Sum in page footer problem 0
Adding Null value in Access Reports 1
Sum a field with null value 5
Do Access Reports recalculate their record source? 7
Using iif Null and 0 5

Top