Problem pulling unique records

[kmclane]

I have a query that is pulling data from four different tables. For some reason it is returning multiple rows for the same records. Here is my SQL Statement

SELECT Qry_ExportSQL.ID, AgentSortCode.CBLAgentNumber, AgentSortCode.AgentName, Qry_ExportSQL.[Date/Time], Qry_ExportSQL.Material, matcost.Cost, Qry_ExportSQL.[Merchant Number]
FROM matcost INNER JOIN (EOMVisaMC INNER JOIN (Qry_ExportSQL INNER JOIN AgentSortCode ON Qry_ExportSQL.ID = AgentSortCode.ID) ON EOMVisaMC.Sort = AgentSortCode.SortCode) ON matcost.Matcode = Qry_ExportSQL.Material;

I have an autonumber field included, but I cannot for the life of me figure out how to limit the records returned. Could someone help out please.

Thanks, Ken

 

[Joe4]

I was never good at ready other people's SQL code, but here are a few things that may help:

Make use of "SELECT DISTINCT" instead of "SELECT" to return only unique rows. I am not sure if it will work with the links you have.

Another option I use when using Access's query builder is Group the records and return the First of each grouping.

Hope this helps!