Thank you for the feedback! Lynn

Here's the simplified version of my table Structure:

GroupID col1 col2 col3 col4

1 ...

Thank you for the reminder Luis!

Will do so now!

For everyone else's info.

Here's my whole solution:

CREATE FUNCTION [dbo].[FnSplit]

(@List nvarchar(2000),@SplitOn nvarchar(5))

RETURNS @RtnValue table

(Id int identity(1,1),Value nvarchar(100))

AS

BEGIN

While (Charindex(@SplitOn,@List)>0)

Begin

Insert Into @RtnValue (value)

Select Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1)))

Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List))

End

Insert Into @RtnValue (Value)

Select...

Thank you so much for pointing it out! Craig

I'll try and let you know!

BTW I like your motto too!

Thank you for your reply! I feel the same way. But I don't have much knowledge for .net. Hopefully someone did something similar before can help on it!

Hi, Bob

You guys are SQL genius. IT does look much cleaner that way.

Do you think the first line should be changed to:

set @start = coalesce(@startdate, dateadd(yy,-1,@enddate), dateadd(yy,-1,getdate())

Thank you again!...

Hi, Tim

Thank you for your reply!

My question is that the [sample barcode] only shows on the sub-report but I need to generate a search field on the main report for...