Trigger Sum

[MiCro]

I am new so please excuse my SQL ignorance:

My trigger is working, EXCEPT for the fact that it is NOT INCLUDING the most recently inserted value in the CommentHRS field in the sum (CA_TOTALhrs).  

Trying to be clear here:  It's properly calculating the SUM on the insert event, but just not including the newly inserted value as part of the sum.  

(The actions with the red X work fine.  No problems there.)     Why would it not include the value that was just inserted in the SUM?

Thanks.  Mike 

 

 

[Glitch]

You should add the sum to the inserted Value.

 

Reading the trigger, You are only summing up the CommentHRS. Meaning to say, the inserted one is still excluded, since you are  still on the process of inserting the Data.

 

I hope this helps.