Null Value

[CharlesCount via AccessMonster.com]

How do I get a query to enter a zero value so I can calculate the difference.
I have a table with 200 items (Stock) and I want to deduct the items used
(TableUsedItems), some period of time no items are ure used but I want to
dispay all items but when I deduct from all itmes I do not get a balance
number where the used field is blank.

Thank you

 

[Guest]

Use the NZ function or IIF([x] Is Null, 0, [x]).

 

[CharlesCount via AccessMonster.com]

Use the NZ function or IIF([x] Is Null, 0, [x]).

How do I get a query to enter a zero value so I can calculate the difference.
I have a table with 200 items (Stock) and I want to deduct the items used

[quoted text clipped - 3 lines]

Thank you

Thanks