Banquet Table Assignments

[Guest]

I would like to create a database for a conference which entails basic
registration info, workshop choices and banquet attendance. There are 2
banquets and attendees can choose to sit with friends. Is there a way, and if
so how, to have the database automatically do the table assignments? They are
10 per table and attendess have to submit registrations together if they
request to sit with someone.

Thought maybe someone might of done this for their wedding table assignments?

Any suggestions? ~Thanks~

 

[Allen Browne]

Store the data in a table with fields such as:
Surname
FirstName
TableNum
TablePos
where "TableNum" is the table number, and TablePos is a position number at a
table (1 - 10.)

Create a crosstab query that uses:
- TableNum as a RowHeading
- TablePos as a ColumnHeading
- FullName: First(Trim([FirstName] & " " & [Surname]))
as an expression used as the Value.

In the query's ColumnHeadings property, enter the numbers 1 to 10 (separated
by commas) so it knows there are 10 positions at a table.

Create a report based on this crosstab query. In the Detail section, draw a
rectangle to represent the table, and place the fields (1 to 10) in the
correct places at the table.

The report will now represent the seating plan for your banquet.

Naturally, you can print other layouts as well, such as an alphabetic
listing of guests with their table number and table postion beside each
name.

If you prefer, you can create the query by switching to SQL View (view menu
in query design), and pasting this in:

TRANSFORM First(Trim([FirstName] & " " & [Surname])) AS FullName
SELECT TableNum
FROM tblGuest
GROUP BY TableNum
PIVOT TablePos In (1,2,3,4,5,6,7,8,9,10);