'stack or union multiple fields in MS Access

Beginner's question here... I have a table of tree measurements being 3 fields: - ID, Diameter_1, Diameter_2

& I wish to get to these 3 fields: - ID, DiameterName, DiameterMeasurement Input and Desired Output

SELECT DISTINCT ID, Diameter_1
FROM tblDiameters
UNION SELECT DISTINCT ID, Diameter_2
FROM tblDiameters;

Though it results in only 2 fields. How may the field: - DiameterMeasurement be brought in?

Many thanks :-)

sql ms-access

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source