Thank you Willem

It worked a treat.

I have also made some other alterations to normalize the data.

I put Agent names in to a seperate table and joined it to my query.

Also...

Many Many thanks Lutz.

That worked a treat

Andy

Its just clicked.

I replaced GROUP BY Printer with

GROUP BY SUBSTRING(Printer,1,CHARINDEX(@PrinterEnd,Printer)-1)

Full query is:

DECLARE @CopyStart VARCHAR(10),

@CopyEnd ...

Its just clicked.

I replaced GROUP BY Printer with

GROUP BY SUBSTRING(Printer,1,CHARINDEX(@PrinterEnd,Printer)-1)

Full query is:

DECLARE @CopyStart VARCHAR(10),

@CopyEnd ...

If I wanted to get this query to work on SQL Server 2000 what method would I need.

I can't use views because you can't declare variables in views.

I tried nested...

That makes a lot of sense Jeff thankyou.

The database holds thousands and thousands of records so I will definately benefit from the speed aspect.

Just one question.

you have set the third...

Thanks Lutz

I used your second suggestion and it worked a treat.

Thanks once again for the expert advice on this Forum

Andy

Thanks Jeff

I have been doing some reading up on Substring and charindex as you suggested.

I came up with this query and it works great.

DECLARE

@CopyStart varchar(10),

@CopyEnd varchar(10),

@PrinterStart varchar(10),

@PrinterEnd varchar(10)

SET @CopyStart =...

Yes, sorry I forgot to say I added an extra column called comments.

I have since had a play around and if I use a details view to update the records...

Thanks SSC Veteran that worked a treat.

I now have my grid view displaying the correct data. I renamed the column headers and

i've added conditional formatting on the cells and now...

Once again Toni you have come up with the solution.

I can't tell you how much I appreciate it. I consider myself as a novice and its nice to know that...

Thanks once again Toni.

I have put in to practice what you said and all works great. I have tailored it to meet my needs such as change the rid column...

Thanks Toni

I really appreciate the time you've taken to help me out.

I will apply all what you said and let you know how I got on.

Once again thank you ever...