What is the query that is being run?

This is the way the data is on the old system. I have no idea how it works but last time I worked with it the data was grafted into...

Unfortunately that is the way the data is held in that old system. It runs very slowly because of the way it holds data which of course is one of...

There is nothing on Row 2 that identifies it as such or links it to Row 1, that is my problem.

The data is sales order data from a legacy system. It comes in as a row with the order header info (the 20000 number is the customer number) then the...

In my example the first three rows are:

20000 0

NULL 1

NULL 1

Luke

Working back from current row back until it finds a column A value that isn't NULL and use that value. Working down from Row 2 this will be previous row?

Luke

Lynn,

Thanks for the quick reply

That looks good. Now if I have multiple parts how can I build up a table that contains all the various combinations for all the parts...