thanks Gila here is what i have in my table and indexes.

[Order Date] [smalldatetime] NULL,

[Order Num] [int] NULL,

[Item Num] [varchar](20) NULL,

[Item Short Desc] [varchar](100) NULL,

[Order Qty] [int] NULL,

[Item Class Short...