Ask Experts Questions for FREE Help !
Ask
    enchanting01's Avatar
    enchanting01 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 13, 2009, 12:57 PM
    Access Query to convert colums and rows
    Okay, this is what I have been beating my head trying to do...

    I have two tables similar to the following

    Table1:
    Product_ID | Size
    b1234 | L
    b1234 | XL
    c3567 | S
    c3567 | M
    c3567 | L

    Table2:
    Product_ID | Description
    b1234 | Cool T-Shirt
    c3567 | Awesome T-shirt

    I need to combine the two tables so that it looks like this:
    Product_ID | Description | Size
    b1234 | Cool T-Shirt | L, XL
    c3567 | Awesome T-Shirt | S, M, L

    Any help would be greatly appreciated!
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jan 13, 2009, 01:01 PM

    I've posted a link to an article that will do what you need:

    Utter Access Discussion Forums - Code To Concatenate Multiple Records Into A Single Field=

    Basically what you need to do is loop through the records in Table 1 and concatenate the size values.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Schedule for Access Query [ 1 Answers ]

Hi, I need to run some Access queries at midnight please help me in regards. I saw some articles related to MACRO but for them I must have to open the Access Database. Is there any thing like SQL Queries can be run from Command Prompt and we can make 1 cmd file to put in Windows schedule

Convert Access MDb to Exe [ 1 Answers ]

I am using Access 2003 I want convert the database into exe

Access Query Design [ 10 Answers ]

Hi all, I am new to the site and would appreciate any help. I have set of data I am having trouble with. I have one table which contains a series of “Assignment IDs”, products and the dates for which those products were matched to those Assignment IDs. The second table is grouped by product...

Run MS access query as exe [ 1 Answers ]

Hi, I have to run few queries one after another. I created a form, so now I can run them in sequence with just 1 click of a button. It there a way that I can start running those queries by just loading the form and not clicking any button. My main aim is to have a schedule task so Access...

Update Query in Access [ 1 Answers ]

Hi there! How can I update different records differently in one field based on different criteria? Can I use the update query for that? Do I have to use a macro? Thanks for the help!

View more questions Search