Greetings,
I have been working on a database for a school system. This database tracks the teacher absences and the reason for the absences; ex: Sick day, Family Illness, Jury duty. I am trying not to hard code the type of absences into the subreport, but allow it to change as reasons are changed or added into the database.
I have a table that stores the absence dates and the reason for the absence. The problem I am having is this: Say there are 10 different reasons for absences and the teacher only has used 5 of them, how do I get the subreport to show '0' for all the absence reasons that didn't show up in the table that stores the absences. I tried using temp tables with update queries, but that was a dismal failure.
I have one week to figure this out, while the school is out on their week break. Any help will be greatly appreciated.
Blessed be
Doreen
.
I have been working on a database for a school system. This database tracks the teacher absences and the reason for the absences; ex: Sick day, Family Illness, Jury duty. I am trying not to hard code the type of absences into the subreport, but allow it to change as reasons are changed or added into the database.
I have a table that stores the absence dates and the reason for the absence. The problem I am having is this: Say there are 10 different reasons for absences and the teacher only has used 5 of them, how do I get the subreport to show '0' for all the absence reasons that didn't show up in the table that stores the absences. I tried using temp tables with update queries, but that was a dismal failure.
I have one week to figure this out, while the school is out on their week break. Any help will be greatly appreciated.
Blessed be
Doreen
.