Thanks Steve, I had been testing things and finally worked through it, and you were dead on with that. Here is the before and after code in case anyone else may be interested.

Before....didn't work............

..

..

IF (SELECT HospitalID FROM deleted) IN (1098,2440,2481,2770,4165,4427,4603,6184,6564)

BEGIN

INSERT INTO [Nursery_Transactions]

SELECT 'D',

[HospitalID],

[CollageID],

GETDATE()

FROM deleted

END

..

..

After.......did work..........

..

..

INSERT INTO [Nursery_Transactions]

SELECT 'U',

[HospitalID],

[CollageID],

GETDATE()

FROM deleted

WHERE deleted.[HospitalID] IN (1098,2440,2481,2770,4165,4427,4603,6184,6564)