Luke L (9/21/2010)
Why doesn't it matter which in records 1-2? If it doesn't matter why return that column at all?-Luke.
Ok,
ColumnA is a shipping number.
Each shipping number may have several orders in it.
Therefore, it is repeated, once for every order. I did not include the order number column, since I don't need it. Each unique shipping number is a load.
I want to count how many loads there are, and for different delivery date time periods, hence columnB and columnC.