Timeline for VB.Net error with CASE SELECT
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 17, 2016 at 15:05 | vote | accept | Smarton | ||
| Apr 16, 2016 at 21:43 | comment | added | Andriy M |
@Smarton: IF IS NULL then SINGLE else keep the value of the field. In your case, it could be SUM(Nz(sr.itemunits, 0)) or SUM(IIf(IsNull(sr.itemunits), 0, sr.itemunits)), although, to be honest, I don't really understand why store NULL at all in such cases. But of course I don't know all the details, maybe there's a good reason for that.
|
|
| Apr 16, 2016 at 21:32 | comment | added | Smarton | How do I ensure SUM(sr.itemunits) returns 0 in the case of NULL?? | |
| Apr 14, 2016 at 15:01 | history | answered | Andriy M | CC BY-SA 3.0 |