Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
katarina07
Starting Member
31 Posts |
 Posted - 2005-11-07 : 10:14:00
|
| Hi, is there a way how to have zeroes instead of empty fields in a crosstab query?I would like to do it as simply as possible.Thanks, Katarina |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-11-07 : 10:48:07
|
| If your cross tab expression is SUM(Amount), instead ofTRANSFORM Sum([Amount])You can wrap the NZ() function around it to replace nulls with zero:TRANSFORM Nz(Sum([Amount]),0) AS AmtOr, format Null values as "0" on your report or form that is displaying these results.Read up on NZ() in the Access help files. |
 |
|
|
katarina07
Starting Member
31 Posts |
Posted - 2005-11-08 : 03:20:44
|
| Thanks jsmith, it works.katarina |
|
|
|
|
|
|
No empty fields in cross-tab query