Can't calculate two fields if one field is empty

[Lei]

I want to track parts QTY delivered and recieved from two campany sections , as below:

Section A Section B
Delivery Receive

Part Name QTY Part Name QTY

Pump Cover 60 Pump Cover 60
6T30 Bolt 320 6T30 Bolt 320
Cup PlugCup Plug 180 Cup PlugCup Plug 180
GearSet 60

The report I made to track delivery and receive variance by deducting QTY under same part name. Therefore if the balance is "0", the delivery and receive is matched. However, the report that I made is just listed the matched parts and QTY as below:

Part Name Delivery Receive Variance
Pump Cover 60 60 0


6T30 Bolt 320 320 0
Cup PlugCup Plug 180 180 0

can't list 60 GearSet that not received , why ?

[CJ_London]

can't make sense of you sample data but suspect you either have a null value (in which case use the nz function) or your query is using an inner join and records exist in one table, but not the other (in which case use a left join)

[alansidman]

A little confused by your explanation, but I believe that you need to embed your calculation expression in an NZ function.

Look at this link to understand the NZ function.

http://www.techonthenet.com/access/f...dvanced/nz.php

[Lei]

[QUOTE=Lei;309262]I want to track parts QTY delivered and recieved from two campany sections , as below:

Thank you for you reply, to clarify my question, please refer to table below:

Date Part Name Beginning Balance Received fr Supermarket 2016-01-27 Body HD 6T45 Finish 75 860 2016-01-27 Bolt 700 10,500 2016-01-27 Lip Seal 120 240

Date Shift No Part Name Part No Pack QTY Per Pack Delivered by Received by Total QTY 2016-01-27 01 Body HD 6T45 Finish 215 4 lo 860 2016-01-27 01 Bolt 10 11,000 lo 11,000 2016-01-27 01 Lip Seal 2 120 lo 240 2016-01-27 01 TCC Valve 5 120 lo 600

Part Name Shift No Line Total QTY Received fr Supermarket Check Body HD 6T45 Finish 01 GF6 Line 1 860 860.00 0 Bolt 01 GF6 Line 1 11,000 10,500 500 Lip Seal 01 GF6 Line 1 240 240. 0

The Cross Check is a query that is to track the parts QTY from the form of Shift Report -01 and Supermarket Delivery. Those parts existed in both forms could be listed in the query of Cros Check, but part of TCC Valve in form of form Supermarket delivery, but not show in Shift Report -01 could not disply in the query of Cross Check. ? ? ?

Lei

[CJ_London]

without knowing the code to your crosscheck, would just be guessing