Duplication of records in query

[Skip Bisconer]

I have the following query based on a table Investments
and a query Income Table Summary:
SELECT Investments.Company, Investments.Symbol,
Investments.[Asset Type], Investments.[Financial Account],
[Investments]![Cost Price]*[Investments]![Quantity] AS
[Cost Basis], Investments.[Market Price], [Income Table
Summary].[Sum Of Income Amount], [Investments]![Market
Price]+[Income Table Summary]![Sum Of Income Amount]-[Cost
Basis] AS Gain, [Gain]/[cost basis] AS [Percent Gain]
FROM Investments INNER JOIN [Income Table Summary] ON
Investments.InvestmentsID = [Income Table
Summary].InvestmentID;

I have some of the records duplicating. Can someone help
me?

Thanks

Skip

 

[Guest]

I found my own problem. Sorry if I wasted anyones time.
Skip