N
NielsE
This is probably a beginner question. However, I have the following query:
SELECT tblPROJECTS.Projectsymbol, tblPROJECTS.Title, tblPROJECTS.StatusDate,
tblPROJECTS.Budget, tblPROJECTS.Status, tblPROJECTS.Region,
tblProjectSubject.SubjectName, tblPROJECTS.ProjectID
FROM tblPROJECTS INNER JOIN tblProjectSubject ON tblPROJECTS.ProjectID =
tblProjectSubject.ProjectID;
based on two tables where there is a one-to many elationship between
ProjectID (autonumber) and SubjectName. Thus the query returns many records
where, for example, the ProjectID is repeated.
I only need records with unique ProjectIDs. How do I do that?
Niels
SELECT tblPROJECTS.Projectsymbol, tblPROJECTS.Title, tblPROJECTS.StatusDate,
tblPROJECTS.Budget, tblPROJECTS.Status, tblPROJECTS.Region,
tblProjectSubject.SubjectName, tblPROJECTS.ProjectID
FROM tblPROJECTS INNER JOIN tblProjectSubject ON tblPROJECTS.ProjectID =
tblProjectSubject.ProjectID;
based on two tables where there is a one-to many elationship between
ProjectID (autonumber) and SubjectName. Thus the query returns many records
where, for example, the ProjectID is repeated.
I only need records with unique ProjectIDs. How do I do that?
Niels