Apologies, I should have mentioned, my bad. I had tried that way but it did work but as I have 2 query in the crosstab and one query has work packages (WP) that apply to all members and one field WiKCredit for specific MemberID and I want to display the Member Name for that. If I do it the above way it displays WP for only WiKCredit. In the SQL below it displays the MemberID.
PARAMETERS [Forms]![APLTBLFRM]![ProjectID] Long;
TRANSFORM Sum(Nz([CurrentBudget]*[MemberShare]/[Total Share],0)) AS MemberCost
SELECT [TestingProjectWPTable Query].ProjectID, [TestingProjectWPTable Query].WPNumber, [TestingProjectWPTable Query].WPName, [TestingProjectWPTable Query].DocumentType, [TestingProjectWPTable Query].CurrentBudget, [TestingProjectWPTable Query].SumOfSumOfMemberShare AS [Total Share], [TestingProjectWPTable Query].WiKCredit, [TestingProjectWPTable Query].MemberID
FROM TestProjectCostFieldsJPPQRY INNER JOIN [TestingProjectWPTable Query] ON TestProjectCostFieldsJPPQRY.ProjectID = [TestingProjectWPTable Query].ProjectID
WHERE (((TestProjectCostFieldsJPPQRY.ProjectID)=[Forms]![APLTBLFRM]![ProjectID]))
GROUP BY [TestingProjectWPTable Query].ProjectID, [TestingProjectWPTable Query].WPNumber, [TestingProjectWPTable Query].WPName, [TestingProjectWPTable Query].DocumentType, [TestingProjectWPTable Query].CurrentBudget, [TestingProjectWPTable Query].SumOfSumOfMemberShare, [TestingProjectWPTable Query].WiKCredit, [TestingProjectWPTable Query].MemberID
ORDER BY [TestingProjectWPTable Query].DocumentType DESC
PIVOT [TestProjectCostFieldsJPPQRY].[MemberName] & ", Share " & [TestProjectCostFieldsJPPQRY].[MemberShare];