How can you get an Access CrosstabQuery to advise zero values in the total column?
S Sherry Sep 3, 2004 #1 How can you get an Access CrosstabQuery to advise zero values in the total column?
D Duane Hookom Sep 3, 2004 #2 You set the Value to something like: Val(Nz(Sum([YourField]),0)) If this doesn't help then come back with your current SQL View.
You set the Value to something like: Val(Nz(Sum([YourField]),0)) If this doesn't help then come back with your current SQL View.
