{"id":94,"date":"2009-12-15T10:36:31","date_gmt":"2009-12-15T15:36:31","guid":{"rendered":"http:\/\/wukenny.host-ed.net\/?p=94"},"modified":"2009-12-15T10:36:31","modified_gmt":"2009-12-15T15:36:31","slug":"use-cross-join-in-ms-access","status":"publish","type":"post","link":"http:\/\/kennywu.info\/?p=94","title":{"rendered":"Use Cross Join In MS Access"},"content":{"rendered":"<p>Our Microsection report needs to have same serial number for each and every hole type. Using VBA to generate a table, which has a field of hole_type and a field of SN, sure will work. However; a proper and elegant way is to use a cross join to link two tables.<\/p>\n<p>Tbl_Hole:<br \/>\nH_Type\u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0\u00c2\u00a0 Text \u00c2\u00a0 \u00c2\u00a0 (PTH; Blind_Via; Micro_Via etc)<br \/>\nH_Name \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 Text \u00c2\u00a0 \u00c2\u00a0 (Thermal Stress; As is; L1-3; L8-9 etc)<\/p>\n<p>Tbl_SN:<br \/>\nSN \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 Text \u00c2\u00a0 \u00c2\u00a0 (1, 2, 3, 4, 5, etc)<\/p>\n<p>SQL (qry_HoleType_SN):<br \/>\n<code>SELECT *<br \/>\nFROM tbl_Hole, tbl_SN;<\/code><\/p>\n<p>From a graphical query builder<br \/>\nAdd both tables and ensure there is no link between them.<\/p>\n<ul><\/ul>\n<p>Below is what I got.<\/p>\n<p>H_Type\t\tH_Name\tSN<br \/>\nBlind Via\tL1-2\t1<br \/>\nBlind Via\tL1-2\t2<br \/>\nBlind Via\tL1-2\t3<br \/>\nBlind Via\tL1-2\t4<br \/>\nBlind Via\tL1-2\t5<br \/>\nBlind Via\tL8-9\t1<br \/>\nBlind Via\tL8-9\t2<br \/>\nBlind Via\tL8-9\t3<br \/>\nBlind Via\tL8-9\t4<br \/>\nBlind Via\tL8-9\t5<br \/>\nPTH\t\tAs Is\t1<br \/>\nPTH\t\tAs Is\t2<br \/>\nPTH\t\tAs Is\t3<br \/>\nPTH\t\tAs Is\t4<br \/>\nPTH\t\tAs Is\t5<br \/>\nPTH\tThermal Stress X\t1<br \/>\nPTH\tThermal Stress X\t2<br \/>\nPTH\tThermal Stress X\t3<br \/>\nPTH\tThermal Stress X\t4<br \/>\nPTH\tThermal Stress X\t5<br \/>\nPTH\tThermal Stress Y\t1<br \/>\nPTH\tThermal Stress Y\t2<br \/>\nPTH\tThermal Stress Y\t3<br \/>\nPTH\tThermal Stress Y\t4<br \/>\nPTH\tThermal Stress Y\t5<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Our Microsection report needs to have same serial number for each and every hole type. Using VBA to generate a table, which has a field of hole_type and a field of SN, sure will work. However; a proper and elegant &hellip; <a href=\"http:\/\/kennywu.info\/?p=94\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[21],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-database","tag-cross-join-access"],"_links":{"self":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94"}],"version-history":[{"count":0,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions"}],"wp:attachment":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}