I uploaded a file called RosterReDo.zip which can be located in Monthly Roster report problem.
I've got to make this monthly report and would like to do it on one report which is a sample in the zip file. These assignments should be selected on whether they wish to participate in this activity, which would be indicated by a Yes in the Active field, and Yes in each activity's field. Some people cannot do these duties in the evening or on Wednesday, and that can be indicated by Yes or No in those fields.
Each person chosen should be chosen by the latest served date so no one has to accomplish a dudy too often. Also, no one should be chosen for weekly duties if they have been assigned monthly duties, and not more than one duty per week.
I've accomplished this using blank reports filled with subreports over 2 pages, but I've had to manually choose whether it is a 4 week Sunday and 4 week Wednesday month or other combinations of those two days.
In my database which I've not uploaded I used somwhere around 300 queries, Appending chosen people to 5 (one for each week of the month) different tables, filtered that data and placed that into sub reports, then updated the served date of those individuals so they may not get chosen for the next week's duties.
I was hoping for an easier method to accomplish all of this without using the sub reports.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar