I seem to have the same problem. I am creating an access
to, among many other things, keep attendance of the
members of a civic service club and compute various
attendance percentages. I, of course, have a table that
includes the members names. I have created a new form
that uses the ActiveX Calendar control and allows the user
to input the dates of all club functions. This form
creates another table that has all events and the dates of
these events. Now I would like to create another new
table that has the members names in rows and the dates of
these events in columns. I can from that table create a
form with all of the members names and all of the events
and the user can just check those events each member
attended.

So, I am asking the same question. How can I create a
table that uses data from another table as the names of
the fields?

Bob