Hello,
I am a novice with MS Access so I want to apologize ahead of time with
the fact that I know very little about Access.
I have an Access database that keeps track of volunteers and assigns
them out to specific events(this is a high end entertainment center).
They of course have volunteers that come in for specific events who
donate their time and they are generally assigned to take tickets,
tend bar, serve as ushers at various doors. Each volunteer has been
assigned job codes, some have 1 job code and some have several job
codes...depending on the experience they have had. Such as ticket
takers we have a code of TT, ushers the code is US, etc. Now I have
to produce a Roster report and on the report I have to list the
various locations such as for ushers where they would be assigned
to.....such as Left Lobby Door and a Right Lobby Door, Mezzanine both
Left and Right, Grand Tier Right and Left....etc. The number of
ushers they assign to each of these locations is dependant on the
house size....for instance a house size 1 would only assign 1 usher to
Lobby Left and 1 usher to Lobby Right, where a house size 2 would
assign 2 ushers to Lobby Left and 2 ushers to Lobby Right and so
forth....we go up to house size 6. I have used different queries and
subReports but still have not be able to solve the problem. I have
been pulling my hair out!!!!!
Can anyone help me with this problem?
Doris