General discussion
June 14, 2001 at 09:35 AM
matar711

how do u merge results of queries

by matar711 . Updated 24 years, 11 months ago

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

This discussion is locked

All Comments