Thanks for the message,

the whole union query is

SELECT 1 as MyID, ActivityDate as [Activity Date], tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, SiteRCM as MyValue, "Site RCM" as MyCode  
from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 2 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, SBSSO as MyValue, "SBS SO" as MyCode from
tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 3 as MyID, ActivityDate as [Activity Date], tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, SiteQME as MyValue, "Site QME" as MyCode
from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 4 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, CorpQMER as MyValue, "Corp QMER" as
MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 5 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, CorpQME as MyValue, "Corp QME" as MyCode
from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 6 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, QualityTimeHour as MyValue, "Quality
Hour" as MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 7  as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA, QualityTimeMinute as MyValue, "Quality
Minute" as MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 8 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, EscalatedCall as MyValue, "Escalated
Call" as MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 9 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name +
" " + tblEmployee.Last_Name as EDA, TrainingPackets as MyValue, "Training
Packets" as MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 10  as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA, IKBOutStanding as MyValue, "IKB
Outstanding" as MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 11  as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA, CSRatWork as MyValue, "CSR work" as
MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 12 as MyID,  ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA, CSRAbsent as MyValue, "CSR Absent" as
MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0
UNION

SELECT 13 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA, TimeCardSubmit as MyValue, "Time Card
Submit" as MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 14 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA, OTHours as MyValue, "OT Hours" as
MyCode from tblEDAActivity
INNER JOIN tblEmployee on tblEDAActivity.EDA_ID = tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 15 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails
where  tblEDAActivityPlanMeetingDetails.EDA_ID = tblEmployee.Employee_ID  and
tblEDAActivityPlanMeetingDetails.MeetingElements = 1 and datediff("d",
meetingdate, now) = 0 ) as MyValue,
"AHT Plan Meeting" as MyCode
from  tblEDAActivityPlanMeetingDetails
INNER JOIN tblEmployee on  tblEDAActivityPlanMeetingDetails.EDA_ID =
tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 16 as MyID,  tblEDAActivityPlanMeetingDetails.ActivityDate as
[Activity Date],  tblEmployee.first_name + " " + tblEmployee.Last_Name as
EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails
where  tblEDAActivityPlanMeetingDetails.EDA_ID = tblEmployee.Employee_ID  and
tblEDAActivityPlanMeetingDetails.MeetingElements = 2 and datediff("d",
meetingdate, now) = 0 ) as MyValue,
"IKB Plan Meeting" as MyCode
from  tblEDAActivityPlanMeetingDetails
INNER JOIN  tblEmployee on  tblEDAActivityPlanMeetingDetails.EDA_ID =
tblEmployee.Employee_ID
WHERE DateDiff("d",  tblEDAActivityPlanMeetingDetails.ActivityDate, now()) = 0

UNION

SELECT 17 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails
where  tblEDAActivityPlanMeetingDetails.EDA_ID = tblEmployee.Employee_ID  
and
tblEDAActivityPlanMeetingDetails.MeetingElements = 3 and datediff("d",
meetingdate, now) = 0 ) as MyValue,
"CSI Plan Meeting" as MyCode
from  tblEDAActivityPlanMeetingDetails
INNER JOIN tblEmployee on  tblEDAActivityPlanMeetingDetails.EDA_ID =
tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 18 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails
where  tblEDAActivityPlanMeetingDetails.EDA_ID = tblEmployee.Employee_ID  and
tblEDAActivityPlanMeetingDetails.MeetingElements = 4 and datediff("d",
meetingdate, now) = 0) as MyValue,
"ATT Plan Meeting" as MyCode
from  tblEDAActivityPlanMeetingDetails
INNER JOIN tblEmployee on  tblEDAActivityPlanMeetingDetails.EDA_ID =
tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 19 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails
where  tblEDAActivityPlanMeetingDetails.EDA_ID = tblEmployee.Employee_ID  and
tblEDAActivityPlanMeetingDetails.MeetingElements = 5 and datediff("d",
meetingdate, now) = 0 ) as MyValue,
"ACC Plan Meeting" as MyCode
from  tblEDAActivityPlanMeetingDetails
INNER JOIN tblEmployee on  tblEDAActivityPlanMeetingDetails.EDA_ID =
tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0

UNION

SELECT 20 as MyID, ActivityDate as [Activity Date],  tblEmployee.first_name
+ " " + tblEmployee.Last_Name as EDA,
(Select count(*) from tblEDAActivityPlanMeetingDetails
where   tblEDAActivityPlanMeetingDetails.EDA_ID = tblEmployee.Employee_ID
and   tblEDAActivityPlanMeetingDetails.MeetingElements = 6 and datediff("d",
meetingdate, now) = 0) as MyValue,
"SO Plan Meeting" as MyCode
from  tblEDAActivityPlanMeetingDetails
INNER JOIN tblEmployee on  tblEDAActivityPlanMeetingDetails.EDA_ID =
tblEmployee.Employee_ID
WHERE DateDiff("d", ActivityDate, now()) = 0;

and crosstab query is following

TRANSFORM Sum([SP GET CROSS TAB ACTIVITY  DETAILS].MyValue) AS SumOfMyValue
SELECT [SP GET CROSS TAB ACTIVITY  DETAILS].MyID, [SP GET CROSS TAB ACTIVITY
DETAILS].MyCode, Sum([SP GET CROSS TAB ACTIVITY  DETAILS].MyValue) AS [Total
Of MyValue]
FROM [SP GET CROSS TAB ACTIVITY  DETAILS]
GROUP BY [SP GET CROSS TAB ACTIVITY  DETAILS].MyID, [SP GET CROSS TAB
ACTIVITY  DETAILS].MyCode
PIVOT [SP GET CROSS TAB ACTIVITY  DETAILS].EDA;

Thanks again,