I have the following query that does not work, if i remove of of the
sets of data from it if works fine, is there somthing i have to do
whne i have 3 or more sets of data

Thanks

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

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

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