Vertically merge two similar queries into one list? 1

[DAmoss]

Hi,

I'm trying to join to queries together into one vertical list, but I seem to be failing miserably! Can some one help and tell me where I'm going wrong? I really need to create one long list from both sets of values

Both of my queries have the same fields:

[Gend]
[PCR Output Description]

Here's my SQL code so far:

SELECT [PCR Qst 5-3-1-C Unemployed day before starting sub list].GEND, [PCR Qst 5-3-1-C Unemployed day before starting sub list].[PCR Output Description]
FROM [PCR Qst 5-3-1-C Unemployed day before starting sub list]
UNION
SELECT [PCR Qst 5-3-1-E Unemployed day before starting sub list].GEND, [PCR Qst 5-3-1-E Unemployed day before starting sub list].[PCR Output Description]
FROM [PCR Qst 5-3-1-E Unemployed day before starting sub list];

 

[PHV]

What is the problem ?
If ,missing records then use UNION ALL

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

 

[DAmoss]

PHV:

It's me forgetting the good old 'UNION ALL' to give me all my required records!

Thanks for reminding & helping me again, problem solved!