I created a crosstab to run days in office. If they take time off it gives a value, if they are in all day it leaves it blank. I would like to return a zero showing that they were in the office that day. I used Sum(Val(Nz([Subject],0))). In the total tab I used expression. Still blanks!
May i have some help please
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.