Edited: Thinking about it, you probably don't need that third table. Try this: -

SELECT A.Portfolio, B.PortfolioID, SUM(B.MarketValue) AS SumOfMV,

COUNT(B.SecID) AS [# of Securities]

From ERTutAccounts A

INNER JOIN ERTutPositions B ON A.PortfolioID = B.PortfolioID

GROUP BY ERTutAccounts.Portfolio, ERTutPositions.PortfolioID;[/quote]

This one worked!! Only issue was with the GROUP BY Query. I had to switch the ERTutAccounts to A.Portfolio and ERTutPositions to B.PortfolioID