If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple
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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|