Yes I will post the solution tomorrow from work.

And i don't necessarily have a running total, All I did was sum the total quantity of items received and subtracted...

Hello guys, first of all thanks all for the help.

In no way was I trying to yell at you I was posting from my laptop and disregarded caplocks (Funny how...

UPDATED BY THE WAY

I updated my post with the info

--===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL DROP TABLE #mytable

--===== Create...

Let me set up the data so you're able to see it.

By the way I appreciate your help.

Yes, its for inventory management.

Basically i need to know what was received on a sales order and what's still needed?