Complicated Select Query

Lisad

Access Beginner
Local time
Today, 08:15
Joined
Jan 26, 2005
Messages
31
I have 3 tables that i wish to pull information from:-
TBLProspects
LeadID (Primary Key)
CompanyName
RenewalDate
Status

TBLNotes
NoteDate
Note
Who
LeadID

TBLQuotes
QuotePremium
Income
Reason
OnCoverPremium
LeadID

I have created the query and at the moment, I am getting duplicated rows of "Note" because there are more than one "QuotePremium" for each CompanyName. Is there anyway of showing the CompanyName, the Note (just once) and then the 2 or 3 QuotePremiums records?

SELECT DISTINCT TBLNotes.NoteDate, TBLProspects.CompanyName, TBLProspects.RenewalDate, TBLNotes.Note, TBLProspects.Status, TBLQuotes.QuotePremium, TBLQuotes.Income, TBLQuotes.Reason, TBLQuotes.OnCoverPrem
FROM (TBLProspects INNER JOIN TBLNotes ON TBLProspects.LeadID = TBLNotes.LeadID) INNER JOIN TBLQuotes ON TBLProspects.LeadID = TBLQuotes.LeadID;
 
Yes, but this does not make any difference.
 

Users who are viewing this thread

Back
Top Bottom