D
dave.j
I'm pretty new to Access, but hope I can get some help for an all-volunteer
organization that provides a week-long camp for high school students.
I would like add a workshop section to our registration database (Access
2003) that sorts from a participants top 3 choices, for two workshop times. I
am struggling making it clear, but here it goes...
Workshop Possibilities:
Time 1
Time 2
Time 1+2
Time 1 may have a choice between 8 workshops, i.e. W1, W2, W3, W4... W8.
Time 2 may have some repeated workshops, plus others, i.e. W3, W5, W9,
W10... W15
Some workshops may require both times, combined (Time 1+2).
Students would be able to mark their top three on a paper form, someone
would input the data and have the database sort it all out. Workshops would
have max # of participants.
I don't expect to get a program, but that would be great...
Is this possible? What type of program or function would this be? Just that
would help a bunch.
organization that provides a week-long camp for high school students.
I would like add a workshop section to our registration database (Access
2003) that sorts from a participants top 3 choices, for two workshop times. I
am struggling making it clear, but here it goes...
Workshop Possibilities:
Time 1
Time 2
Time 1+2
Time 1 may have a choice between 8 workshops, i.e. W1, W2, W3, W4... W8.
Time 2 may have some repeated workshops, plus others, i.e. W3, W5, W9,
W10... W15
Some workshops may require both times, combined (Time 1+2).
Students would be able to mark their top three on a paper form, someone
would input the data and have the database sort it all out. Workshops would
have max # of participants.
I don't expect to get a program, but that would be great...
Is this possible? What type of program or function would this be? Just that
would help a bunch.