Hi,

I have 3 text boxes. txtA - txtB = txtC

txtA is the sum of a query based on my stock history table.
txtB is the sum of a query based on quantity of goods despatched.

My problem is that if no goods have ever been despatched, txtB has no value.

I would like to know what to do here as I have tried various things with the Nz and IFF functions on the txtB box.

Can anyone offer any advice?

Thanks
Simon