new table with 5 old table records merged

[oexall]

Hello Everyone,


I have a table, Sales, each record of which is a customer and sales amount and zip.
I want to construct a new table that has each record as the top five sales in each 3 digit zip area, with sale
and name of each customer:

so for all 787 zip codes, one record will look like:

787 customer1 sales1 customer2 sales2 etc.

I think that I can make summary records but not "merged data" records.

Please help and thank you

[June7]

You want the top five sales record for each 3 digit zip? Review: http://allenbrowne.com/subquery-01.html#TopN