Error in adding null values in query

[confuse]

I've posted this question before but until now i cant solve this problem of mine..

Can anyone do help me with this?

I have a problem in adding the values in my query,if one of it has a null value it will not display any value at all. I've done already the NZ function but still it doesn't work..

I've uploaded the sample file here..


Help is greatly appreciated,.,.,Thanks

 

[Alansidman]

It looks like you did not define what you want your fields to be if they are null. Take a look at this for how to set up your Nz function. The format is NZ(variant,[value_if_null]). You are missing the value if null piece.

http://www.techonthenet.com/access/functions/advanced/nz.php

 

[confuse]

It looks like you did not define what you want your fields to be if they are null. Take a look at this for how to set up your Nz function. The format is NZ(variant,[value_if_null]). You are missing the value if null piece.

http://www.techonthenet.com/access/functions/advanced/nz.php

Thanks for the reply..

I applied it but still it doesnt work...

No values has been display in the query.

 

[WayneRyan]

Confuse,

Get your query in Design View.

Right-Click on the lines "joining" the tables.

Change the join type to 2 (Include all records from Products).

Is that what you mean?

Wayne

 

[confuse]

Confuse,

Get your query in Design View.

Right-Click on the lines "joining" the tables.

Change the join type to 2 (Include all records from Products).

Is that what you mean?

Wayne

Wayne,,


Thanks a lot... It works...Thank you very much