Recent content by tagah

  1. T

    Question Update only 1st record out of multiple?

    Thanks ByteMyzer, that worked like a charm!!
  2. T

    Question Update only 1st record out of multiple?

    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?
  3. T

    Question Update only 1st record out of multiple?

    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?
  4. T

    Question Update only 1st record out of multiple?

    THese are order # numbers...
  5. T

    Question Update only 1st record out of multiple?

    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...
  6. T

    Duplicates

    It doesn't work. It does not combine duplicate records. I need to select all columns as well.
  7. T

    Duplicates

    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...
Back
Top Bottom