{"published":"2008-09-13 00:00:00","author_name":"accs2014","blog_title":"\u3082\u3046\u4e00\u5ea6\u5b66\u3076MS-Access","url":"https://www.accessdbstudy.net/entry/20080913/p1","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.accessdbstudy.net%2Fentry%2F20080913%2Fp1\" title=\"FLOOR\u95a2\u6570\u3068CEILING\u95a2\u6570\u3092\u5b9f\u73fe\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>","height":"190","provider_name":"Hatena Blog","title":"FLOOR\u95a2\u6570\u3068CEILING\u95a2\u6570\u3092\u5b9f\u73fe\u3059\u308b","author_url":"https://blog.hatena.ne.jp/accs2014/","description":"\u3042\u308b\u6570\u5024\u3092\u3001\u6307\u5b9a\u3057\u305f\u6570\u5024\u306e\u6574\u6570\u500d\u306b\u4e38\u3081\u308b\u3001\u3044\u308f\u3086\u308b\u5e8a\u95a2\u6570\u3068\u5929\u4e95\u95a2\u6570\u306b\u3064\u3044\u3067\u3059\u3002 EXCEL\u3067\u306fFLOOR\u95a2\u6570\u3068CEILING\u95a2\u6570\u3068\u3057\u3066\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u304cAccess\u306b\u306f\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u306e\u3067\u3001\u3053\u3053\u3067\u306fInt\u95a2\u6570\u3092\u4f7f\u3063\u3066\u5b9f\u73fe\u3057\u307e\u3059\uff08\u305f\u3060\u3057\u30de\u30a4\u30ca\u30b9\u306e\u6570\u5024\u306b\u3064\u3044\u3066\u306f\u8003\u616e\u3057\u3066\u3044\u307e\u305b\u3093\uff09\u3002 \u4f8b\u3068\u3057\u3066\u53f3\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u8a18\u9332\u3055\u308c\u3066\u3044\u308b\u305d\u308c\u305e\u308c\u306e\u6570\u5024\u3092\u30017\u306e\u500d\u6570\u306b\u4e38\u3081\u3066\u307f\u307e\u3059\u3002 \u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u3001\u6b21\u306e\u3088\u3046\u306a\u5217\u3092\u8a2d\u3051\u307e\u3059\u3002 \u5e8a\u304cFLOOR\u95a2\u6570\u3001\u5929\u4e95\u304cCEILING\u95a2\u6570\u306b\u5bfe\u5fdc\u3057\u307e\u3059\u3002 \u5e8a: Int([\u6570\u5b57]/7)*7 \u5929\u4e95: -Int(-[\u6570\u5b57]/7)*7 \u5f53\u7136\u3067\u3059\u304c\u305d\u308c\u305e\u308c\u306e\u5217\u306b2\u3064\u305a\u3064\u3042\u308b\u300c7\u300d\u306f\u30017\u306e\u500d\u6570\u306b\u4e38\u3081\u308b\u2026","version":"1.0","categories":["Access Tips"],"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/accs2014/20170307/20170307232916.png","provider_url":"https://hatena.blog","width":"100%","blog_url":"https://www.accessdbstudy.net/"}