I have an Order Line which goes with the order #.
Order # Order Line
340639 191949
340639 191950
340463 191725
340463 191728
345082 197289
344073 196105
Cant I do sumtin like if the top record is less than the next one...make the top one equal to 13?
OK Well
Here is an example.
Order # Product # Qty Fee
20012 CE0011 2
20012 CE0012 1
20012 CE0014 4
20013 CE0011 1
20013 CE0026 1
I want to only a fee to the first record of each order #. How does this help?
Can anyone help me on how update the 1st record out of the multiple. Look below..I have this data:
Order # Fee
20010 13
20010
20010
20011 13
20011
20012 13
I want my table to look like this. Is there anyway I can do this without updating the empty ones. I only want...
Hi does anybody know how to get combine duplicate lines and quantities.
Client Code -- Order # -- Client Name -- Qty -- Style #
SI001 200100 Mike Civ 1 MLX-1568
SI001 200100 Mike Civ 1 MLX-1568
SI001...