C
Chris75 via AccessMonster.com
Hello,
Within a report, I have a textbox called Absence. This textbox gives me a
list of five possible absences (present, sick, vacation, training and stat
holiday). Within this report, I am able to get the total of each absence for
a period of time. However, I would like to divide only two of these
individual totals by five (present and vacation). Present has an AbsenceID
value of 1 and Vacation has an AbsenceID value of 3.
Right now, to get the totals, I have a text box called Count *. This gives
the total count for each absence in the period I have selected. I also have
a textbox called DayTotal. It is here where I would like to show the divided
figures for AbsenceID 1 and AbsenceID 3 only.
In the DayTotal textbox of the report, I wrote the following in the Data
Control Source : =Sum([AbsenceID]=1)/5. This works, however I would also
like to show the same thing for AbsenceID 3 in the same report, such that
when I view the report, I will see the totals for all five categories, but I
will only see the DayTotal for two of the five categories.
Any ideas?
Thank you
Within a report, I have a textbox called Absence. This textbox gives me a
list of five possible absences (present, sick, vacation, training and stat
holiday). Within this report, I am able to get the total of each absence for
a period of time. However, I would like to divide only two of these
individual totals by five (present and vacation). Present has an AbsenceID
value of 1 and Vacation has an AbsenceID value of 3.
Right now, to get the totals, I have a text box called Count *. This gives
the total count for each absence in the period I have selected. I also have
a textbox called DayTotal. It is here where I would like to show the divided
figures for AbsenceID 1 and AbsenceID 3 only.
In the DayTotal textbox of the report, I wrote the following in the Data
Control Source : =Sum([AbsenceID]=1)/5. This works, however I would also
like to show the same thing for AbsenceID 3 in the same report, such that
when I view the report, I will see the totals for all five categories, but I
will only see the DayTotal for two of the five categories.
Any ideas?
Thank you