The query worked like a charm. Thanks Newbie

Thanks I will let you know how it works. Appreciate everyones help

A random sample would be perfect

Thanks for the input I am new to this and could not find another thread that fit what I needed.

I can see where this would be hard to understand....

The script I am using is SELECT         CLAIMLIN.[adjusr] AS [User ID],  

                max(CLAIMLIN.[GRPNUM]) AS [Group Number],

                max(CLAIMLIN.[CLAIMNO]) AS [Claim Number],               

                max(CLAIMLIN.[STATCD]) AS [Status]

 into #temp456

        FROM FMH.DBO.Claimlin Claimlin

        WHERE CLAIMLIN.[SVCDAT] BETWEEN...