Use Cross Join In MS Access

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.

Tbl_Hole:
H_Type             Text     (PTH; Blind_Via; Micro_Via etc)
H_Name           Text     (Thermal Stress; As is; L1-3; L8-9 etc)

Tbl_SN:
SN                   Text     (1, 2, 3, 4, 5, etc)

SQL (qry_HoleType_SN):
SELECT *
FROM tbl_Hole, tbl_SN;

From a graphical query builder
Add both tables and ensure there is no link between them.

    Below is what I got.

    H_Type H_Name SN
    Blind Via L1-2 1
    Blind Via L1-2 2
    Blind Via L1-2 3
    Blind Via L1-2 4
    Blind Via L1-2 5
    Blind Via L8-9 1
    Blind Via L8-9 2
    Blind Via L8-9 3
    Blind Via L8-9 4
    Blind Via L8-9 5
    PTH As Is 1
    PTH As Is 2
    PTH As Is 3
    PTH As Is 4
    PTH As Is 5
    PTH Thermal Stress X 1
    PTH Thermal Stress X 2
    PTH Thermal Stress X 3
    PTH Thermal Stress X 4
    PTH Thermal Stress X 5
    PTH Thermal Stress Y 1
    PTH Thermal Stress Y 2
    PTH Thermal Stress Y 3
    PTH Thermal Stress Y 4
    PTH Thermal Stress Y 5