Mucho gracias, merci beaucoup and dziękuję bardzo Rod. This query was
driving me nutty; not knowing why it wasn't working. I will definitely
implement your improved code in the database when the time comes.

And you are right on your assumptions, tblInventoryA has one row per
batchcode and there are not multiple fields/(rows) for LossedorTossed for
each batchcode.

AG