That works, too! Thanks 😀

Thanks! That works great on the sample. Now I'll try to implement in with my "real" tables and data and see what happens.:-D

Here are some very basic schemas with a small amount of data:

CREATE TABLE testInventoryTran(

IntTranIDVARCHAR(10)NOT NULL,

IntLineINTEGERNOT NULL,

IntLotIDVARCHAR(10)NOT NULL)

CREATE TABLE testBarrelCount (

BrcTranIDVARCHAR(10)NOT NULL,

BrcLineINTEGERNOT NULL,

BrcBarrelCountINTEGERNOT NULL)

CREATE TABLE testBarrels (

BrlBarrelIDVARCHAR(10)NOT NULL,

BrlLotIDVARCHAR(10)NOT NULL,

BrlDateDATETIMENOT NULL)

INSERT INTO...