Accessã§å
¨è§âåè§ï¼åè§âå
¨è§ï¼ã«ãããï¼StrConv颿°ï¼[Access],ã¤ã©ã¤ã©ããäºå使¥ããµã¯ãµã¯ããªããæãã¹ãã¬ã¹è§£æ¶æ³ããç´¹ä» ã¹ãã¬ã¹ããªã¼ã§åãã¾ããâ è¥å¹²ã®éåæãããããããã¾ãããããäºæ¿ãã ããï¼ï¼ ã¾ãã¯ãæ¥ä»ã®æ¸ãæ¹ããè¦ã¦ããã¾ãããã å¹³æ30å¹´1æ1æ¥ã¨ç¸¦æ¸ãã§æ¼¢æ°åãç¨ãã¦æ¸ãããã¨ãã«ã¯ããããªãã¾ãï¼ ã¾ããæ¨ªã«åããæ°åãæåããã©ã°ãã¦é¸ã³ã¾ããããæ¬¡ã«ã¡ãã¥ã¼ãã¼ã§ãæ¸å¼ãâãæ¡å¼µæ¸å¼ãâãç¸¦ä¸æ¨ªãã¨ã¯ãªãã¯ï¼å³2ï¼ãç¾ããç»é¢ã®ããã¬ãã¥ã¼ãæ¬ã§æåã®åãã確èªãã¦å¤æ´ã㾠⦠ãä½ã£ã¦å°åããããã¨ãã¦ãã¾ãã çæ³ã¯ã使 ã§1è¡ãé£ã« 建ç©å ã§1è¡ã¨ãããã®ã§ãã æ°åãæ¨ªæ¸ãã§æ¸ãå ´åã«ã¯ ç®ç¨æ°åï¼1ã2ãªã©ï¼ã使ç¨ãã¾ãã åºæ¬çã« ãç¥åãªã©ã®ç§çãªãã®ã§ã¯æ¸ãæ¹ã«æ±ºã¾ãã¯ããã¾ããã ä¼è¨ãç»è¨ãæ¸ç±ãªã©ã® é¨åã®æååã®åãã90度å転ããããã®ã§ããããããã£ããã¨ã¯å¯è½ãªã®ã§ããããã ãåç¥ã®æ¹ãããã£ãããã¾ããããææãã ããã ãã®ä»(ãã¼ã¿ãã¼ã¹) - 使ã®å®åã縦æ¸ãã§è¡¨ç¤ºãããã®ã§ãããåè§æ°åãå
¨è§ã«å¤æããã¨ãäºæ¡ä»¥ä¸ã®æ°åã¨ãã¤ãã³ããããããªããã¨ãçºè¦ãã¾ããã äºæ¡ä»¥ä¸ã®æ°åã縦並ã³ã§ ⦠ãåè§ã»å
¨è§ããã¡ãã¨Accessç¨ã«çµ±ä¸ããã¨ããªã㨠è±èªã ãæ¨ªåãã«è¡¨ç¤ºããããããã æ¼¢æ°åã使ãå ´é¢ã¯ ææ¸ããç¥åããè¦èãã ãªã©ã§æ°åã縦æ¸ãã«æ¸ãã¨ãã«ä½¿ç¨ãã¦. ã¨ã¯ã»ã«ã§ã¯æåã縦æ¸ãã«ãããã¨ãã§ãã¾ãããæ°åã縦æ¸ãã«ãªãã®ã§è¦æ ããæªããªãã¾ããä»åã¯æ°åã ããæ¨ªæ¸ãã«ããæ¹æ³ãç´¹ä»ãã¾ããæ°åã¯2æ¡ã3æ¡ãokãªæ¹æ³ãªã®ã§ãã²åèã«ãã¦ã ⦠縦æ¸ãã®è¨å®ã§å
¥åãã¦ãããããã¤ãã³ã横ã«åãã¦ãã¾ã 使ç¨ãã¦ãããã©ã³ãã縦åãã®ãã¤ãã³ãæã£ã¦ããªãå ´åããã¤ãã³ã¯æ¨ªåãã®ç¶æ
ã§è¡¨ç¤ºããã¾ãã ¨éï¼½ã鏿ãã¦ãï¼»æ°åãæ¼¢æ°åã«å¤æããï¼½ã®ãã§ãã¯ãã¤ãã¾ãã ã§ã³ã®ã«ã¿ã«ãé¨åãæåãæ¨ªã®ã¾ã¾ç¸¦æ¸ãã«ãªã£ã¦ãã¾ãã¾ãã å¹´è³ç¶ãæä¸è¦èããæ®æè¦èããªã©ã§ãã¬ãã«ä½æãæ¸ãã¨ãã«ã縦æ¸ãã ã¨æ°åã¯ã©ããã£ã¦æ¸ãã°ããã®ã§ããããï¼ æ¼¢æ°åï¼ ããã¨ãç®ç¨æ°åï¼ ããã§ã¯ã䏿¡ã®æ°åãã10ã20ã3æ¡ä»¥ä¸ã®æ°åã®å ´åã縦æ¸ãã ã£ãããã¯ããã«ã©ããã£ã¦æ¸ãã°ããã®ããã¾ã¨ãã¦ãã¾ãã 使ã®å®åã縦æ¸ãã§è¡¨ç¤ºãããã®ã§ãããåè§æ°åãå
¨è§ã«å¤æããã¨ãäºæ¡ä»¥ä¸ã®æ°åã¨ãã¤ãã³ããããããªããã¨ãçºè¦ãã¾ããã äºæ¡ä»¥ä¸ã®æ°åã縦並ã³ã§ãªã"123"ã®ããã«æ¨ªã§è¡¨ç¤ºããã¤ãã³ã¯"ï½"ITmediaã®Q&Aãµã¤ããITé¢é£ãä¸å¿ã«çããã®ãæ©ã¿ã»çåãã³ãã¥ããã£ã§è§£æ±ºã ãããããæå±é¨ç½²ãã縦æ¸ãç¡ãã«ãã¦ãã¾ãã ãã®ããã«æ°åãæ£å¸¸ã«è¡¨ç¤ºããã¦ãã¾ãã æ¨ªå¹
ã大ãããªãã¨æ¨ªè¤æ°æåã表示ããã¦ãã¾ãã®ã§1æååã®å¹
ã«ãã¦ã ã»ã³ã¿ã¼æãã«ãã¦ãã¾ãã ãæ°è¦ã«è²¼ãä»ããããæ¼ãã°ã縦æ¸ãã®æåãè²¼ãä»ãã¾ãã®ã§ã試ãä¸ããã ä¸è¨ã®é
ç®ãããå°ãã®å
容ã«ãã¦ã¯ã¾ããªãå ´åã¯ããææ°ã§ãããä¸è¨ãããåãåãããã ããã ã§ãã«ãã©ã³ã以å¤ã®ç¨®é¡ã«å¤æ´ãã¾ãã æä½ ãææ¸ã®æ¨æºã®ãã©ã³ããå¤ããå ´åã [ãã¡ã¤ã«-ãã¼ã¸è¨å®]ã鏿ãã¾ãã ï¼Accessã§ä½æãããã¼ã¿ãWordã«è»¢éããæ¨ªæ¸ããã¼ã¿ã縦æ¸ãã«å¤æããã¨ããæ¨ªåãæ°åããç¸¦ä¸æ¨ªãæ©è½ã§ä¿®æ£ããæéãçã ãç¸¦ä¸æ¨ªãã¯Wordã®æ©è½ãªã®ã§ãWordã®ãã¯ãã§å¦çããæ¹ãè¯ãã¨æãã¾ãã ãµã³ãã« ãè¡ããè¦ç©ããä½ãã¨ãã«ä½¿ããããï¼ã¢ã¯ã»ã¹ã§æ°å¤ãæ¼¢å表示ããæ¹æ³ã«ãå°ãã®æ¹ã¯ãåèã«ãã¦ã¿ã¦ãã¦ãã ããã 縦æ¸ãã«ããå ´åã«ã¯ãOrientationãããããã£ã«ãxlVerticalããè¨å®ãã¾ããæ¨ªæ¸ãã«ããå ´åã¯ãxlHorizontalãã¨ãã宿°ãç¨æããã¦ãã¾ããã代ããã«è§åº¦ãæå®ãã¦ãæ§ãã¾ããã è§åº¦ã¯ã-90ãããã90ãã¾ã§ã®ç¯å²ã§è§åº¦ãæå®ãã¾ãã ï¼â»ç¸¦æ¸ã表è¨ãã¬ã¤ã¢ã¦ãã®é½åä¸ã横æ¸ãã§ãç´¹ä»ãã¦ããã®ã§. ç¹ã«ãããªã¯ããã¾ããã æååã縦æ¸ãã§è¡¨ç¤ºããæ¹æ³ã§ãããã©ã¼ã ã¨ã¬ãã¼ãã®ã¿ã§å©ç¨ã§ããããããã£ããããã¼ãã«ãã¯ã¨ãªã«åæ§ã®æ©è½ã¯ããã¾ããã ã¬ãã¼ãã®ããã¹ãããã¯ã¹ã縦æ¸ã表示ãã¦ã¿ã¾ãã ããããã£ã®ãã¡ã縦æ¸ããããã¯ããã«ãã¾ãã èè
/ tatsuo ikura åå¿è
ï½ä¸ç´è
ã®æ¹ã対象ã¨ããããã°ã©ãã³ã°æ¹æ³ãéçºç°å¢ã®æ§ç¯ã®è§£èª¬ãè¡ããµã¤ãã®éå¶ãè¡ã£ã¦ãã¾ãã æ¥ä»/æå»åã®ãã¼ã¿ã Microsoft Access ã§ä½¿ç¨ããã¨ãã¯ãæ¢å®ã®æ¸å¼è¨å®ã®ã¾ã¾ã«ããããå®ç¾©æ¸ã¿æ¸å¼ã® 1 ã¤ãé©ç¨ããããç¬èªã®æ¸å¼ã使ãããã鏿ã§ãã¾ãã ãã®è¨äºã§ã¯ãExcelã§ç¸¦æ¸ãã«ãã3ã¤ã®æ¹æ³ããç´¹ä»ãã¾ãããã¼ã ã¿ãå
ã«ãããæ¹åããã鏿ããæ¹æ³ããã»ã«ã®æ¸å¼è¨å®ããã鏿ããæ¹æ³ã縦æ¸ãã³ãã³ããã¯ã¤ãã¯ã¢ã¯ã»ã¹ãã¼ã«ãã¼ã«ç»é²ããæ¹æ³ã®3ã¤ã§ãã å¹´ææ¥ã®æ¸å¼ãé貨ã®ããæ°ãªã©ããã¼ã¿ãæå®ãã表示形å¼ã«å¤æããã«ã¯Format颿°ã使ç¨ãã¾ãã夿ããå½¢å¼ãæå®ããããã®æ¸å¼æå®æåãç´¹ä»ãã¾ãã ãæ¨ªã«å¯ãç¶æ
ã«ãªãã¾ãã ããã縦æ¸ãã«ç´ãã«ã¯ï¼ã¨ãã質åãåããæä½ãã¦è¦ã¤ããæ¹æ³ããä¼ããã¾ãã ã¨ã¯ã»ã«ã§ã¯æåã縦æ¹åã«ã«ãããã¨ãã§ãã¾ãããããããã¨ãæ°åã䏿åãã¤ç¸¦æ¸ãã«ãªã£ã¦ãã¾ãã¾ããããããæ°åã¯æ¨ªæ¸ãã«ãããã»ã»ã»ãããªã¨ãã«ä½¿ããã縦æ¸ãã®ã»ã«ã§ãæ°åãã¢ã«ãã¡ãããã¯æ¨ªåãã«ããæ¹æ³ãããç´¹ä»ãã¾ãã