Search results

  1. N

    Concatenating Different Records

    Thank you. That issue did cross my mind, the idea was to cheese it by using excel to cull the duplicate records. I am aware of my limitations in progress
  2. N

    Concatenating Different Records

    Thank you Patrice - the temp table is something I haven't considered. I am reading the documentation on this right now. I have a question though, what do you mean with for each tt : /*DO what you want*/ END. What goes in there? The display / output? Thank you
  3. N

    Concatenating Different Records

    Thank you, that hass given me an output. There is an issue though, it is picking up ALL orders, regardless of if they are related. i.,e Order.Number and Previous Order Number. It is just picking up Order.Number + Order Number + Order Number. Ideally it needs to: Finds Order Number -> find...
  4. N

    Concatenating Different Records

    Thank you Marco, You mean like this? I tried this and it doesn't work? IS there something I am missing? Also, what do you mean with "Infinite loop" How do I exit it, if I encounter it with this problem? Thank you!!
  5. N

    Concatenating Different Records

    Thanks Rob, Like you said, not my design. I agree with you. I am looking for the code that is the right combination of FOR EACH, FIND or IF Statement that will concatenate the data in the way I explained. I understand your concern but there is only a maximum of of 5 or 6 orders not 2k. No...
  6. N

    Concatenating Different Records

    Hi I am new to this. Can you please help me: I have a database and I need to "concatenate records" based on fields in a table. Table: Order Field: Order-Number Field: Previous-Order-Number Field: Create-Date I need to be able to find the first "Order ". Then be able to find all the other...
Top