I am creating a one page weekly Production Summary Report with job# down the left and the days of the week broken down by three shifts across the top. I am quering the information into text boxes using the "IIf" function. I would like to have only one line per job on my report but end up with as many lines as there are records per job#, as each record has a quantity that matches one of the 21 text boxes. What should I use as a function to put one total per text box and have only one line without having 0 show up as a false return on my "IIf" statement?
Ex
Sunday Monday Tuesday
Job# A B C A B C A B C
A001 0 5 0 0 0 0 0 0 0
A001 0 0 0 4 0 0 0 0 0
A001 0 0 0 0 0 0 0 0 9
Would like to see
Sunday Monday Tuesday
Job# A B C A B C A B C
A001 0 5 0 4 0 0 0 0 9
Ex
Sunday Monday Tuesday
Job# A B C A B C A B C
A001 0 5 0 0 0 0 0 0 0
A001 0 0 0 4 0 0 0 0 0
A001 0 0 0 0 0 0 0 0 9
Would like to see
Sunday Monday Tuesday
Job# A B C A B C A B C
A001 0 5 0 4 0 0 0 0 9