I have the following Union Query but it does not work, If i remove one
of the qrys it works fine,

How do i do a union query for 3 or more bits of data

Thannks

SELECT qryHotTubsWS.[IDNumber] AS IDNumber,
       qryHotTubsWS.[ProductName] AS ProductName,
       qryHotTubsWS.[Price] AS Price,
       qryHotTubsWS.[ProductCode] As ProductCode,
       'qryHotTubsWS' AS TheType
   FROM qryHotTubsWS

UNION ALL SELECT qryExtrasWS.[IDNumber] AS IDNumber,
       qryExtrasWS.[ProductName] AS ProductName,
       qryExtrasWS.[Price] AS Price,
       qryExtrasWS.[ProductCode] AS ProductCode,
       'qryExtrasWS' AS TheType
   FROM qryExtrasWS

UNION ALL SELECT qryProductsWS.[IDNumber] AS IDNumber,
       qryProductsWS.[ProductName] AS ProductName,
       qryProductsWS.[Price] AS Price,
       qryProductsWS.[ProductCode] AS ProductCode,
       'qryProductWS' AS TheType
   FROM qryProductsWS

ORDER BY IDNumber;