I have a cross tab query that counts the number of jobs done per shift. Shift is a field that is entered as 1,2, or 3. I have:row heading = date, column heading = shift, row heading = ID, row heading = total of jobs, and value = jobs
This is based off of a make table that is made for a specific date range. The problem is sometimes there is nothing for a given shift in a particular date range. So for example when the cross tab query is run, I may get columns for 1st and 2nd shift but 3rd shift will not show up if there weren't any jobs done on 3rd. I would like it to appear anyway with zeros. Can I put in a statement somewhere that says if one of the three values isn't present, return all zeros for it down the column?
This is based off of a make table that is made for a specific date range. The problem is sometimes there is nothing for a given shift in a particular date range. So for example when the cross tab query is run, I may get columns for 1st and 2nd shift but 3rd shift will not show up if there weren't any jobs done on 3rd. I would like it to appear anyway with zeros. Can I put in a statement somewhere that says if one of the three values isn't present, return all zeros for it down the column?
