This works only if the sql command modified a single record.

Vlad

>In the trigger declare old and new values
>
>DECLARE @oldvalue int,@newvalue int
>
>SELECT @oldvalue = (SELECT columnname from deleted)
>
>SELECT @newvalue = (SELECT columnname from inserted)
>
>Now use the @oldvalue and @newvalue in your calculations
>
>HTH
>John
>
>
>>Does anyone know if it's easy to reference both old and new field values via triggers in SQL Server 7.0. e.g. If I was amending a balance detail record and changing the ordered quantity from 10 to 20, I would would want to update the ordered quantity on the balance header record by the (current header value + (new detail value - old detail value)) hence I would need to know what the new and old balance detail ordered quantities were. Thanks.