C10
I have a crosstab with rows of people and colums with each day in a month. The crosstab prints out a distinct count for each person per day to show if they were present or not. If the person has any time info entered into the database for a day, then it prints "1" for that day and if no time info had been entered then it prints "0". I use a distinct count because some people have more then one attendance entry per day and I need to total it for the month. I am able to format the fields with "0" to show up as "-" but I would also like to format the "1"s to something else easier to read. Is there a way to do this?
I have a crosstab with rows of people and colums with each day in a month. The crosstab prints out a distinct count for each person per day to show if they were present or not. If the person has any time info entered into the database for a day, then it prints "1" for that day and if no time info had been entered then it prints "0". I use a distinct count because some people have more then one attendance entry per day and I need to total it for the month. I am able to format the fields with "0" to show up as "-" but I would also like to format the "1"s to something else easier to read. Is there a way to do this?