Duplication of Query results

[Locopete99]

Hi,

I have the following query that I'm testing out.

It should return only 1 record. However it is returning the same record about 5 times.

How do i make it so that it only returns it once?

SELECT Tbl_ShikomiRegister.[Blanket Agreement Number], Tbl_ShikomiRegister.[Account Number], Tbl_ShikomiRegister.[Part  Number], Tbl_ShikomiRegister.Salesman, Tbl_ShikomiRegister.Holon, Tbl_User.login
FROM Tbl_Holonleader, (Tbl_User INNER JOIN Tbl_Areahl ON Tbl_User.[User Name] = Tbl_Areahl.Holonleader) INNER JOIN Tbl_ShikomiRegister ON Tbl_Areahl.Area = Tbl_ShikomiRegister.Holon
WHERE (((Tbl_User.login)=fOSUserName()));

 

[Ranman256]

set the query property to UNIQUE VALUES = YES.

usu: SELECT DISTINCT in the sql.

 

[Locopete99]

Thanks Ranman