Hi

Had a look at Report Builder and was exactly what was needed, after about 5 attempts got the exact layout I needed. Thanks

James

Hi

It is a report that will be generated each month by one of the stores clerks.

I will look into reporting.

James

I have adapted the code to select only items from this month

DECLARE @mydate DATETIME

SELECT @mydate = GETDATE()

SELECT Product, qty, CostCenter, Customer, TotalCost

FROM IssueStock

Where IssueDate between CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101)

AND CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),101)

UNION ALL

SELECT...

The original statement was fine

UPDATE U SET Quantity = U.Quantity + Inserted.q1 FROM Consumables as U INNER JOIN Inserted ON U.Product = Inserted.Product

James

Hi

Sorted. I am using the table in an ASP.NET dynamic data site and there was a naming issue, so the original did work, just the asp.net code was wrong.

Thanks all.

No, it is some code I found, which did work at one point???

I thought this was the inserted table

Hi, here is the structure of the two tables, they seem ok

Yes the trigger looks like that.

No errors.

The trigger is on the table ReceiveOrder that has q1 on it.

James

Hi,Thanks

Tried it but it didn't work.

James

Well I'm new to SQL. I'll check out inserted tables.

James