Lutz,

This is the code I currently have and it mostly works.

-- Use a real table so that I can check what is happening

IF EXISTS (SELECT * FROM sys.objects...

Lutz,

Making some good progress now with your great help.

But I have found 2 issues with the current code.

1) In the original specification of the problem I omited to explain that...

Lutz,

Thank you once again for the great help, it worked beautifully.

However now reviewing the source data, I have found the a very few records are structured slightly differently, with an...

Lutz,

I won't pretend I understand how it works, but it does just what I asked for.

But can I now be a real nuisance and add an additional requirement, to include...

Also check out http://www.reportsurfer.com/

Really neat and just what I was looking for.

Many thanks

Tim

Mine is based on a View

Sorting works just fine for may adp in 2003, but I'm using a slightly different method.

DoCmd.GoToControl "txtCompanyName"

DoCmd.RunCommand acCmdSortDescending

Tim

You may also want to have a look at http://channel9.msdn.com/wiki/default.aspx/Channel9.SQLServer

Tim

See http://www.databasejournal.com/features/mssql/article.php/3459461 and http://www.databasejournal.com/features/mssql/article.php/3483751 for a tutorial on how to set up the RS Execution Logs that Ben refers to.

Rgds

Tim

Problem solved, although I'm not sure why!

I was building the full URL ie: <A href="http:///ReportServer/">http://<server>/ReportServer/<report name etc;>, but if you leave off the <A href="

On the pc - Win XP SP2, with IIS v5.1

On the server - SBS (Small Business Server) 2003, with IIS v6.0.

Maybe, I'm using Remote Desktop to connect to the server, but...

That's one of the troubles when you try to simplifiy things, you leave important bits out

So yes units in stock at the present time...

Sorry I have mixed up field descriptions (case of trying to make the issue simple), so for the purposes of this take InStock = Units.

Sorry about the confusion.

Tim

Oops, sorry I missed that Sergiy had changed the order on the Select line. So you are right it works just fine.

Very many thanks to you all for you help...