Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2004
    Posts
    9

    Unanswered: data question for query

    We have a table that have an auto number filed for primary key and then another id field that can appear more than once. We want to be able to link another field part number to the other id field on one row in a query so we can put it on a form. Can this be done? We have already tried to do a cross tab query but we got too many header errors.

    example

    ID Part #
    1 123
    1 111


    We would like in a query.

    ID Part # Part #
    1 123 111

    Thanks so much.

    Scott
    Last edited by cervesot; 03-17-04 at 16:24.

  2. #2
    Join Date
    Mar 2004
    Posts
    6

    Re: data question for query

    Originally posted by cervesot
    We have a table that have an auto number filed for primary key and then another id field that can appear more than once. We want to be able to link another field part number to the other id field on one row in a query so we can put it on a form. Can this be done? We have already tried to do a cross tab query but we got too many header errors.

    example

    ID Part #
    1 123
    1 111


    We would like in a query.

    ID Part # Part #
    1 123 111

    Thanks so much.

    Scott
    Have you explained this properly? Why would you want 2 part numbers with the same ID, then a secondary ID?

  3. #3
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    is this what you want?
    for e.g
    for an ID no, there are 'n' number of part#

    in the query, should there be (IDNo. + n) columns?
    ID# | Partn1 | Partn2 ....|Partn ?

  4. #4
    Join Date
    Mar 2004
    Posts
    9
    I am sorry if I was not clear. The main ID number is a canadite key. I do not wish to link it to another ID number. Sorry for the confusion.

  5. #5
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    as a followup, that is not possible; however, if you tell me what the form is trying to achieve, i can help you

  6. #6
    Join Date
    Mar 2004
    Posts
    9
    Originally posted by Jerrie
    is this what you want?
    for e.g
    for an ID no, there are 'n' number of part#

    in the query, should there be (IDNo. + n) columns?
    ID# | Partn1 | Partn2 ....|Partn ?


    Yes!!!!

  7. #7
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    yea what i said is not possible; you cant create 'n' number of columsn;
    what bout other id nos, that might have 2 parts vs. another that might have 15?

    however, tell me whats ur aim in creating the form? why do you have to create this query; i can help you then.



    "Nothing is impossible in Access. At least not if you try hard enough"

  8. #8
    Join Date
    Mar 2004
    Posts
    9
    Originally posted by Jerrie
    as a followup, that is not possible; however, if you tell me what the form is trying to achieve, i can help you

    We are trying to let the users view the part numbers on the main form we have based on the id field.

  9. #9
    Join Date
    Mar 2004
    Posts
    9
    Originally posted by Jerrie
    yea what i said is not possible; you cant create 'n' number of columsn;
    what bout other id nos, that might have 2 parts vs. another that might have 15?

    however, tell me whats ur aim in creating the form? why do you have to create this query; i can help you then.



    "Nothing is impossible in Access. At least not if you try hard enough"
    We don't have to create a query at all we were just going that route.

  10. #10
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    then all you need to do in the form is create a new sorting header, and set it to the ID no.

    then below the header, place the PartNo field into the form;

    it should show all the partNo's associated with the ID No.

  11. #11
    Join Date
    Mar 2004
    Posts
    9
    Originally posted by Jerrie
    then all you need to do in the form is create a new sorting header, and set it to the ID no.

    then below the header, place the PartNo field into the form;

    it should show all the partNo's associated with the ID No.

    Thanks for the help. We will give it a try.

Posting Permissions

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