select 0 if null

[xarrisx]

I have this statement

select prod_id, sum(prod_price)
from sells
group by prod_id

sells
----------------------------------------
PROD_ID PROD_PRICE
1 100
2 50
1 200
2 50
3
1 50

-----------------------------------------------
results:
1 350
2 100

PRODUCT 3 is not selected

I want to know if there is a way to get a value of 0 when PROD_PRICE is
null

results:
1 350
2 100
3 0

I AM USING ACCESS

 

[John Vinson]

select prod_id, sum(prod_price)
from sells
group by prod_id

Use the NZ() function:

SELECT Prod_ID, Sum(NZ([Prod_Price))
FROM Sells
GROUP BY Prod_ID;

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps