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!

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.