Limit a company appearance to once only

[Bobp3114]

I have two tables joined by StationID. In a query that shows which companies (stations) have a link (RPCustomerPoNumber) to field in the other table, but I only want to see that company name once. The query is unbound.

SELECT DISTINCT tblRepReport.StationID, tblStationData.[Station Name], tblRepReport.RPCustomerPONumber
FROM tblStationData LEFT JOIN tblRepReport ON tblStationData.StationID = tblRepReport.StationID
WHERE (((tblRepReport.RPCustomerPONumber) Is Not Null))
ORDER BY tblStationData.[Station Name];

Thanks for any help as I thought SELECT DESTINCT would do this. I have tried all join types.
Bob

 

[arnelgp]

that is the Normal records on using Query.
if you want to show only one StationID, Station Name, use a Parent Form->Child subform.

also you can only do that on a Report.

 

[plog]

SELECT DISTINCT tblRepReport.StationID, tblStationData.[Station Name], tblRepReport.RPCustomerPONumber

That is giving you every unique combination of StationID, Name and PO. If you want just one Name, then what values do you want to show for the other 2 fields? You have multiple of those values to choose from--how are you deciding which to show with that one name?

 

[isladogs]

Do you actually need to see the values in the RPCustomerPONumber field or just check that values exist?
Unticking the RPCustomerPONumber field in your query will then show each stationID & name (which has a PONumber) once only

 

[CJ_London]

There is no need for a left join either, just change the link to an inner join and remove the RPCustomerPONumber field from the query grid at the bottom

 

[Bobp3114]

Do you actually need to see the values in the RPCustomerPONumber field or just check that values exist?
Unticking the RPCustomerPONumber field in your query will then show each stationID & name (which has a PONumber) once only

Thanks all..i used isladogs idea with success...I will learn from the other info .

isladogs idea​