Hello Kevin,

Sorry about that, I'm new to this type of forum. Here is the code.

CREATE TABLE [dbo].[Item](

[ItemNo] [nvarchar](255) NULL,

[Desc] [nvarchar](255) NULL

)

INSERT [dbo].[Item] ([ItemNo], [Desc]) VALUES (N'10-LB-Tomato', N'10...

Hello SSChampion,

I'm sorry for the confusion. The result set I'm looking for, should include only lots with transaction dates older than 90 days. Also only interested in transaction type...