How can I make this happen? Example shown.

[sladewilson]

This is basically what my product data looks like:

SKU Name Size Price On-Hand
4900 Bogs Shoe 59.99
4907 Bogs Shoe 6 59.99 11
4915 Bogs Shoe 6.5 59.99 9
4923 Bogs Shoe 7 59.99 14
4934 Regs Shoe 54.99
4955 Regs Shoe 3 54.99 7
4976 Regs Shoe 3.5 54.99 0
4997 Regs Shoe 4 54.99 4

This is what I need to export to my website.
SKU Name Price Options
4900 Bogs Shoe 59.99 Size 6 6.5 7
4934 Regs Shoe 54.99 Size 3 4

My web store is Yahoo. Anyone that knows how the "Option" field works will understand my delima. Notice size 3.5 is not displayed... I don't want to export items to the web for which I have no inventory.

Any help would be greatly appreciated!

 

[Remou]

There are, I think, two FAQs on concatenation in the Access Fora. There are also numerous posts.

 

[lespaul]

FAQ701-4233 is one of them....

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi