I have a simple table with the product number and itz pertaining page number. SOme product numbers have multiple page numbers. I have a query that asks for a product number and returns itz page number(s). When i get a product with multiple page numbers they start to list them in spreadsheet forms. For example you have product 970005 on page 4 and on 5. The result looks like:
970005 4
970005 5
A 2*2 spreadsheet
I want the result to look like this:
970005 4 5
A 3*1 spreadsheet
How is one able to do this???
Please email me if you know…chotawala@aol.com
Thanks soo miuch