How do I avoid multiple entries

[schwabe]

Hello all,

I'm working on a problem where I'd like to narrow the list of customers down by choosing wether they have a project running or not. I would like to use the output data later as source of a combo box.

The data structure consists of two tables:

tabOEM with fields
IDOEM, txtOEMName



and
tabProject with fields
IDProject, txtProjectName, lnkOEM, logRunning

Note, one customer might have several project running.
See also the attached database.

What I'd like to set up now is a query which gives a list of all the customers which have a program running but without dublicates. The query I have attached still shows dublicates. I've tried all three versions of the joint but that's not helping.

Thanks,
Benjamin

[alansidman]

Change your query to add a GroupBy.

SELECT tabOEM.IDOEM, tabOEM.txtOEMName, tabProject.lnkOEM, tabProject.logRunning
FROM tabOEM INNER JOIN tabProject ON tabOEM.IDOEM = tabProject.lnkOEM
GROUP BY tabOEM.IDOEM, tabOEM.txtOEMName, tabProject.lnkOEM, tabProject.logRunning
HAVING (((tabProject.logRunning)=True));

[schwabe]

Exactly what I was looking for. Thanks a lot!