Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Bay Area

    Unanswered: Looking for Quick Solution

    I am looking for a way with queries to put data in a table so that every row has a unique service code and the source codes for each service code are stored in one row. There are no more than 25 source codes.

    Sv Code Source Code
    123 AAA
    123 BBB
    123 CCC
    444 XYZ

    The table created by the queries should store:
    Sv Code Src1 Src2 Src3
    123 AAA BBB CCC ... (from 1 to 25 values stored in separate fields)
    444 XYZ


  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    That would be a crosstab query. the access query wizard can probably explain it better than I can...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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