SQL for "Recruting"
SELECT [Member's Database].Recruiter, Count([Member's Database].Recruiter) AS [Recruit Points]
FROM [Member's Database]
GROUP BY [Member's Database].Recruiter;
SQL for "Membership"
SELECT [Member's Database].Status, [Rank Order].[Rank Order], [Member's Database].[Member Name], [Member's Database].Rank, [Member's Database].Class, [Member's Database].Level, [Senority Points].[Senority Points], [Member's Points].[Loyality Points], [Recruit Points].[Recruit Points], [Senority Points.Senority Points]+[Member's Points.Loyality Points]+[Recruit Points.Recruit Points] AS [Total Primaty Points], Sum([Member's Points].[Tourney Points]) AS [SumOfTourney Points], Sum([Member's Points].[Quest Points]) AS [SumOfQuest Points], [Exp Points].[EXP Points], Sum([Member's Points].[End Game Points]) AS [SumOfEnd Game Points], [Member's Points.Tourney Points]+[Member's Points.Quest Points]+[EXP Points.EXP Points]+[Member's Points.End Game Points] AS [Total Secondary Points]
FROM [Recruit Points] INNER JOIN (((([Member's Database] INNER JOIN [Member's Points] ON [Member's Database].[Member Name] = [Member's Points].[Member Name]) INNER JOIN [Senority Points] ON [Member's Database].[Member Name] = [Senority Points].[Member Name]) INNER JOIN [Exp Points] ON [Member's Database].[Member Name] = [Exp Points].[Member Name]) INNER JOIN [Rank Order] ON [Member's Database].[Member Name] = [Rank Order].[Member Name]) ON [Recruit Points].Recruiter = [Member's Database].Recruiter
GROUP BY [Member's Database].Status, [Rank Order].[Rank Order], [Member's Database].[Member Name], [Member's Database].Rank, [Member's Database].Class, [Member's Database].Level, [Senority Points].[Senority Points], [Member's Points].[Loyality Points], [Recruit Points].[Recruit Points], [Senority Points.Senority Points]+[Member's Points.Loyality Points]+[Recruit Points.Recruit Points], [Exp Points].[EXP Points], [Member's Points.Tourney Points]+[Member's Points.Quest Points]+[EXP Points.EXP Points]+[Member's Points.End Game Points]
HAVING ((([Member's Database].Status)="A" Or ([Member's Database].Status)="R"

);
Those are the exact contents of both queries... the first produces the field 'Recruit Points' that is later used in "Membership" to get 'Total Primary Points'... Like I said, the first query works ferfectly, the results have been verified... but once inserted into the second query the results are bugged and there is no pattern to the buggyness... Thanks again for any help you may have for me.