Union query not counting duplicates 1

[DoctorJDM]

Hi

Have this union query to list all items making up a Job

SELECT QuoteRef,Description,Cost,Type
FRoM qryActualComponents
UNION SELECT QuoteRef,Description,Cost,Type
FRoM qryActualHours
UNION SELECT QuoteRef,Description,Cost,Type
FRoM qryActualOtherItems
UNION SELECT QuoteRef,Description,Cost,Type
FRoM qryActualSheetMaterial
UNION SELECT QuoteRef,Description,Cost,Type
FRoM qryActualSubconCosts
UNION SELECT QuoteRef,Description,Cost,Type
FRoM qryActualTimber;

Am finding that if one of the queries, eg qryActualSheetMaterial contains two identical entries, the union query just includes one of them. It's as if it only counts unique items. Any thoughts?

 

[PHV]

Use UNION ALL ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DoctorJDM]

Great, thanks PHV.