Results 1 to 2 of 2

Thread: sorting problem

  1. #1
    Join Date
    Dec 2003
    Location
    Athens,GR
    Posts
    16

    Unhappy Unanswered: sorting problem

    i want to modify this table:
    employees----address----phone1----phone2----phone 3
    ----------------------------------------------------------------
    John A. keas 19 9515678
    John A. keas 19 9515670
    Mike B. highway 2 8652332
    Mike B. highway 2 8656543
    Mike B. highway 2 8723165

    like this :
    employees----address----phone1----phone2----phone 3
    ----------------------------------------------------------------
    John A. keas 19 9515678 9515670
    Mike B. highway 2 8652332 8656543 8723165

    _________________________________________________
    may seem silly,i know,but i am stuck here days now and i dont know with what to fill my loop.
    thank you in advance.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    sortid employees----address----phone1----phone2----phone 3
    ----------------------------------------------------------------
    1 John A. keas 19 9515678
    2 John A. keas 19 9515670
    1 Mike B. highway 2 8652332
    2 Mike B. highway 2 8656543
    3 Mike B. highway 2 8723165


    Need to get data into this form

    once that is done .. it will be a simple crosstab query

    but need to think how to get data into this format ....
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •