Looking at Access after a long time away.
I have three tables that I need to use for a query
tblProjects ( list of Projects: ProjectID (PK), ProjectName)
tblFunds (list of Funds that own the projects: Fund ID (PK), FundName)
tblProjects_Funds (linking table for the many-to-many relationship between the two tables: ProjectID, FundID, OwnedPercent)
I want a query that produces a row for each property and the two funds that own the most of the project:
Fund1: (FundName--of the fund that owns the highest percentage)
Fund2: (FundName--of the fund that owns the second highest percentage)
How should I get started on this? Thanks!