Hi Luke. Many thanks, I will give that a try.

Thanks,

Phil.

Thanks Brian. Does 3.5 need to be on the server running IIS or my local deve;opment machine?

Many Thanks,

Phil.

Hi Brian. I am using MS Visual Web Developer 2008. I tried adding the reportviewer tool to the toolbox but it was not listed? I have posted another report related...

Thanks Jack. I was just thinking the other day that I read some time back that some conditional selects work more efficiently than others. Just could not remember the best...

Thanks for the response Jack. To digress slightly. I have been asked to modify the query begind the parameter. The Parameter List should only display Suppliers whose SupplierId does not...

Many thanks Grant. I need to adjust my mindset......not a programmer......early days but hope to rise to the challenge.

Phil.

OK, I have found my mistake................should all work fine now. My INNER JOIN was referencing the wrong field!!

Many Thanks,

Phil.

The following returns 17251 rows:

SELECT PartLastCost.PART, Products.Part

FROM PartLastCost INNER JOIN

...

Hi Grant. The field I am updating contains values, could this be a problem or should my query override?

4177 rows have a value of: 0.00000

There are 17521 rows where the...

OK embarrassed by my earlier feeble attempts I have now experienced some success:

UPDATE Products

SET dbo.Products.Cost = dbo.PartLastCost.COST

FROM dbo.PartLastCost

INNER JOIN dbo.Products ON dbo.PartLastCost.PART = dbo.Products.ProductId

WHERE Products.Part = PartLastCost.PART

Never updated as many...

Took a flyer and executed the query. Receive error:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "PartLastCost.PART" could not be bound.

Thanks,

Phil.

Would this work:

UPDATE [Database].[dbo].[Products]

SET Cost = PartLastCost.COST

WHERE Products.Part = PartLastCost.PART

Thanks,

Phil.

It should be UPDATE.

Thanks,

Phil.

Thanks Steve, I will try that.

Phil.

Hello again. I have managed to succesfully schedule email delivery of reports. One final question. A report contains grouping allowing users to expand the Customer Name to reveal the report...