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