find the least number of conflicts between fields in a table

[Guest]

I have a group of persons who have signed up for 44 different activities.
These are in a access table by field (activity). I want to schedule the
activities with the least number of conflicts.

 

[Dave]

I have a group of persons who have signed up for 44 different activities.
These are in a access table by field (activity). I want to schedule the
activities with the least number of conflicts.

great! sounds like an interesting project. have fun with it.

 

[John Vinson]

I have a group of persons who have signed up for 44 different activities.
These are in a access table by field (activity). I want to schedule the
activities with the least number of conflicts.

Please post a bit more detail about your table structure. What
constitutes a "conflict"? Do the Activities have date/time fields
which need to be considered in identifying a conflict?

I'm sure some sort of totals query counting "conflicts" (however those
might be defined given your tables) will do this, but I'm not seeing
the actual table structure.

John W. Vinson[MVP]