Duplicates

[cuttsy]

I feel a bit daft cos this is the second time i've had to ask for help on the same project but here goes.

I have a query to return a list of contact names so that letters can be sent out to them. Each contact has one or several job titles. So one contact could have the job titles 'computing contact' and 'media contact'. The problem I have a mail out for an event aimed at computing and media students I do a query for computing contact OR media contact but when a contact has both these job titles he appers twice and as such would recieve 2 letters. I cant use the duplicate values and duplicate records properties as the field which i need to run the query are different in the 2 records 'computing..' and 'media..'

I am hoping that there is a way to eliminate leaving only onle result for each contactID.

The db is set up as follows:

tblContacts (personID, sName, fName, schoolID)
tblSchools (schoolID, schoolName, add1, add2, add3, postcode, tel, districtID)
tblDistrict (districtID, district)
tblJobTitle (jobTitleID, jobTitle)
tblContactsToJobTitle (personID, jobTitleID)

The query is set up as follows:

jobTitle FROM tbljobTitle - criteria: "Computing Contact" OR "Media Contact"
fName FROM tblContacts
sName FROM tblContacts
add1 FROM tblSchools
add2 FR.... e.t.c.
contactID FROM tblContacttoJobTitles

only those in bold are shown in results.

I hope there is a way to do this. Thanks.

 

[maxmangion]

Add DISTINCT after Select in your SQL statement

 

[cuttsy]

Thanks a lot. your a legend!