find the least number of conflicts between fields in a table

B

borsodi0

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.
 
D

Dave

borsodi0 said:
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.
Click to expand...

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

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.
Click to expand...

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]
 
Top