If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show zeros for null in crosstab query
Hi. I created an crosstab query and would like null cells to show a zero. is
there a way to do this in the property sheet or should i use an expression? Problem is there are many columns in this crosstab and it may be cumbersome to put an expresssion in each column. Thanks for any help! |
#2
|
|||
|
|||
Show zeros for null in crosstab query
Switch your query to SQL view.
The first line should be something like Transform Max(SomeField) As [The Value] Change that to Transform Nz(Max(SomeField), 0) As [The Value] -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "KrispyData" wrote in message ... Hi. I created an crosstab query and would like null cells to show a zero. is there a way to do this in the property sheet or should i use an expression? Problem is there are many columns in this crosstab and it may be cumbersome to put an expresssion in each column. Thanks for any help! |
Thread Tools | |
Display Modes | |
|
|