Union Query Several queries with parameters

[summer01]

I am new to Union Queries and struggling with how to format one that combines about 6 different queries with duplicate field names and contains parameters. I am hoping someone can assist so I can learn better how to do these. Below are are the SQL's for 2 of the 6 queries so you can see how they are formatted. I have looked at several sources and cannot seem to get anything to work.

SELECT Count([BC Facility Closed].[Closed Dt]) AS [CountOfClosed Dt], [BC Facility Closed].[Closed Dt]
FROM [BC Facility Closed]
WHERE ((([Closed Dt]-[Recd Dt])>=0 And ([Closed Dt]-[Recd Dt])<=7))
GROUP BY [BC Facility Closed].[Closed Dt];


SELECT Count([BC Facility Closed].[Closed Dt]) AS [CountOfClosed Dt], [BC Facility Closed].[Closed Dt]
FROM [BC Facility Closed]
WHERE ((([Closed Dt]-[Recd Dt])>=8 And ([Closed Dt]-[Recd Dt])<=21))
GROUP BY [BC Facility Closed].[Closed Dt];

 

[PHV]

And the problem is ?

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

 

[Golom]

For starters, a UNION query generally includes the word UNION. You don't have one here.

SELECT Count([Closed Dt]) AS [CountOfClosed Dt], [Closed Dt]
FROM [BC Facility Closed]
WHERE [Closed Dt]-[Recd Dt] >= 0 
  And [Closed Dt]-[Recd Dt] <= 7
GROUP BY [Closed Dt]

UNION 

SELECT Count([Closed Dt]) AS [CountOfClosed Dt], [Closed Dt]
FROM [BC Facility Closed]
WHERE [Closed Dt]-[Recd Dt] >= 8 
  And [Closed Dt]-[Recd Dt] <= 21
GROUP BY [Closed Dt]

A union query takes its field names from the first SELECT in the Union. The other Select statements must have the same number of fields of the same data types but their names are ignored.

The Union illustrated will eliminate duplicate records (if any) in the result. Use UNION ALL if you want to retain duplicates.

I don't see any parameters in the code you posted.