{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.accessdbstudy.net%2Fentry%2F20080711%2Fp1\" title=\"\u30af\u30ed\u30b9\u96c6\u8a08\u30af\u30a8\u30ea\u3067\u96c6\u8a08\u5024\u304cNull\u3068\u306a\u308b\u306e\u30920\u306b\u3059\u308b - \u3082\u3046\u4e00\u5ea6\u5b66\u3076MS-Access\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/accs2014/","description":"\u7c21\u5358\u306a\u30af\u30ed\u30b9\u96c6\u8a08\u30af\u30a8\u30ea\u306e\u4f8b\u3067\u3059\u3002 \u3053\u306e\u3088\u3046\u306a\u8a2d\u5b9a\u3067\u300c\u91d1\u984d\u300d\u5217\uff08\u6570\u5024\u578b\uff09\u306e\u5408\u8a08\u3092\u8868\u793a\u3057\u3088\u3046\u3068\u3057\u307e\u3059\u304c\u2026 \u8a72\u5f53\u3059\u308b\u5024\u304c\u5b58\u5728\u3057\u306a\u3044\u3068\u3053\u308d\u3067\u306f\u5024\u304c0\u3067\u306f\u306a\u304fNull\u3068\u306a\u308a\u307e\u3059\u3002 \u3053\u306e\u3088\u3046\u306a\u3068\u304d\u306bNull\u3067\u306f\u306a\u304f0\u3068\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3067\u3059\u3002 \u30c7\u30b6\u30a4\u30f3\u30d3\u30e5\u30fc\u306b\u623b\u3063\u3066\u3001\u5358\u7d14\u306b\u300c\u91d1\u984d\u300d\u3092\u300cNz([\u91d1\u984d],0)\u300d\u306a\u3069\u3068\u3057\u305f\u304f\u306a\u308a\u307e\u3059\u304c\u305d\u308c\u3067\u306f\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002 \u305d\u3053\u3067\u30d5\u30a3\u30fc\u30eb\u30c9\u6b04\u306e\u5f0f\u3092\u6b21\u306e\u3088\u3046\u306b\u3057\u3001\u3055\u3089\u306b\u96c6\u8a08\u6b04\u3067\u300c\u6f14\u7b97\u300d\u3092\u9078\u629e\u3057\u307e\u3059\uff08\u3053\u3053\u304c\u91cd\u8981\uff09\u3002 \u91d1\u984d\u306e\u5408\u8a08: CLng(Nz(Sum([\u91d1\u984d]),0)) CLng\u95a2\u6570\u3067\u56f2\u3093\u3067\u3044\u308b\u306e\u306fNz\u95a2\u6570\u307e\u3067\u3060\u3068\u623b\u308a\u5024\u304c\u6587\u5b57\u5217\u306b\u306a\u308b\u305f\u3081\u3067\u3059\u304c\u3001\u3053\u3053\u3092\u3069\u306e\u95a2\u6570\u306b\u3059\u308b\u304b\u306f\u9069\u5b9c\u9078\u629e\u2026","width":"100%","categories":["Access Tips"],"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/accs2014/20180527/20180527235204.png","title":"\u30af\u30ed\u30b9\u96c6\u8a08\u30af\u30a8\u30ea\u3067\u96c6\u8a08\u5024\u304cNull\u3068\u306a\u308b\u306e\u30920\u306b\u3059\u308b","blog_title":"\u3082\u3046\u4e00\u5ea6\u5b66\u3076MS-Access","type":"rich","height":"190","provider_url":"https://hatena.blog","author_name":"accs2014","blog_url":"https://www.accessdbstudy.net/","provider_name":"Hatena Blog","url":"https://www.accessdbstudy.net/entry/20080711/p1","published":"2008-07-11 00:00:00","version":"1.0"}