Thread: Matrix Creation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Matrix Creation

Access Query Select Query.
As long as the data is in different tables, and you bring it together in a
query, you will see all possible combinations of arrangements.

Regards,
Ryan---


Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

Just use a standard duplicate bridge seating chart for 16 people.
--
Gary''s Student - gsnu200782


"Mike H." wrote:

I am going to a party. There will be 16 guests and 4 tables with 4 chairs at
each table. There are 6 courses of food being served and after every course
served the hostess wishes to reseat people so that at the end of the 6
courses each guest sat with as many other guests as possible and minimized
sitting at the same table with any particular guest. Anyone have an idea how
to create code to do this?