S
Scott
Thanks to (e-mail address removed) for the response on the subqueries. I
now need to take this a step further and add a couple of calculated
fields into the mix. I've tried a variety of versions this morning, but
I'm getting nowhere. Can someone help?
Here's where I stand:
SELECT
A.[# of Positions],
B.[# of Leader Positions with no planned back-up],
C.[percent of Leader Positions with no planned back-up],
D.[# of Leader Positions with no ready back-up],
C.[percent of Leader Positions with no ready back-up]
FROM
(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]) AS A,
(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]) AS B,
CALCULATION FOR C WOULD GO HERE... WOULD BE THE COLUMN B RESULT /
COLUMN A RESULT.
(SELECT Count([t_Eng Leadership Master].[Leader Name]) AS [# of Leader
Positions with no ready back-up]
FROM (SELECT DISTINCT [Leader Name] FROM [t_Eng Leadership Master]
WHERE [Readiness] <> "Now") AS [Leadership Position Data]) AS D;
CALCULATION FOR E WOULD GO HERE... IT WOULD BE THE COLUMN D RESULT /
COLUMN A RESULT.
Can someone make a suggestion on how to handle the calcuation
subqueries?
Thanks!
Scott
now need to take this a step further and add a couple of calculated
fields into the mix. I've tried a variety of versions this morning, but
I'm getting nowhere. Can someone help?
Here's where I stand:
SELECT
A.[# of Positions],
B.[# of Leader Positions with no planned back-up],
C.[percent of Leader Positions with no planned back-up],
D.[# of Leader Positions with no ready back-up],
C.[percent of Leader Positions with no ready back-up]
FROM
(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]) AS A,
(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]) AS B,
CALCULATION FOR C WOULD GO HERE... WOULD BE THE COLUMN B RESULT /
COLUMN A RESULT.
(SELECT Count([t_Eng Leadership Master].[Leader Name]) AS [# of Leader
Positions with no ready back-up]
FROM (SELECT DISTINCT [Leader Name] FROM [t_Eng Leadership Master]
WHERE [Readiness] <> "Now") AS [Leadership Position Data]) AS D;
CALCULATION FOR E WOULD GO HERE... IT WOULD BE THE COLUMN D RESULT /
COLUMN A RESULT.
Can someone make a suggestion on how to handle the calcuation
subqueries?
Thanks!
Scott