barbara58554
New Member
- Joined
- Dec 7, 2016
- Messages
- 4
I'm working on an attendance form that has columns showing P, T, W, etc that indicate if the child was in school or why the child was absent. A couple columns over are 3 columns showing if the child was served breakfast, lunch and/or snack. I want the days the child was gone to automatically fill with a 0 in the breakfast, lunch, snack columns. I have been trying to figure this out most of the day and finally seek your assistance.
Hope this visual helps:
<tbody> </tbody>
Hope this visual helps:
M | T | W | T | CHILD'S NAME | BREAKFAST | LUNCH | SNACK | B | L | S | B | L | S | B | L | S |
A | P | P | P | I want this column to display 0 if A, T, OR W is in 1st column | I want this column to display 0 if A, T, OR W is in 1st column | I want this column to display 0 if A, T, OR W is in 1st column | I want this column to display 0 if A, T, OR W is in 2ND column | I want this column to display 0 if A, T, OR W is in 2ND column | I want this column to display 0 if A, T, OR W is in 2ND column | I want this column to display 0 if A, T, OR W is in 3RD column | I want this column to display 0 if A, T, OR W is in 3RD column | I want this column to display 0 if A, T, OR W is in 3RD column | I want this column to display 0 if A, T, OR W is in 4TH column | I want this column to display 0 if A, T, OR W is in 4TH column | I want this column to display 0 if A, T, OR W is in 4TH column | |
<tbody> </tbody>