S
Scott
I am getting started with subqueries, working to create a report on
leadership data. Can you give me some advice as I try to blend three
queries into one?
Here are the three queries:
--Count of the unique leadership positions at the company:
SELECT Count([t_Eng Leadership Master].[Leader Pernr]) AS [# of
Positions]
FROM (SELECT DISTINCT [Leader Pernr] FROM [t_Eng Leadership Master])
AS [Leadership Position Data];
--The count of unique leader postions with no backup
SELECT Count([t_Eng Leadership Master].[Leader Name]) AS [# of Leader
Positions with no planned back-up]
FROM (SELECT DISTINCT [Leader Name] FROM [t_Eng Leadership Master]
WHERE [Candidate Name] IS NULL) AS [Leadership Position Data];
--The count of unique leader positions with no backup rated as ready
"Now"
SELECT Count([t_Eng Leadership Master].[Leader Name]) AS [# of Leader
Positions with no planned back-up]
FROM (SELECT DISTINCT [Leader Name] FROM [t_Eng Leadership Master]
WHERE [Readiness] <> "Now") AS [Leadership Position Data];
Can you show me how to blend these into one query?
Thanks!
Scott
leadership data. Can you give me some advice as I try to blend three
queries into one?
Here are the three queries:
--Count of the unique leadership positions at the company:
SELECT Count([t_Eng Leadership Master].[Leader Pernr]) AS [# of
Positions]
FROM (SELECT DISTINCT [Leader Pernr] FROM [t_Eng Leadership Master])
AS [Leadership Position Data];
--The count of unique leader postions with no backup
SELECT Count([t_Eng Leadership Master].[Leader Name]) AS [# of Leader
Positions with no planned back-up]
FROM (SELECT DISTINCT [Leader Name] FROM [t_Eng Leadership Master]
WHERE [Candidate Name] IS NULL) AS [Leadership Position Data];
--The count of unique leader positions with no backup rated as ready
"Now"
SELECT Count([t_Eng Leadership Master].[Leader Name]) AS [# of Leader
Positions with no planned back-up]
FROM (SELECT DISTINCT [Leader Name] FROM [t_Eng Leadership Master]
WHERE [Readiness] <> "Now") AS [Leadership Position Data];
Can you show me how to blend these into one query?
Thanks!
Scott