嗨!!! Jayanta





请使用此查询

Hi!!! Jayanta


use like this query

<pre lang="SQL">SELECT Customers.CompName, Customers.Add, Customers.City, Customers.ContactName, Customers.Phone
FROM Customers
WHERE (((Customers.CompName) In (SELECT [CompName] FROM [Customers] As Tmp GROUP BY [CompName],[Add],[City] HAVING
Count(*)>1 And [Add] = [Customers].[Add] And [City] = [Customers].[City])))
ORDER BY Customers.CompName, Customers.Add, Customers.City;

ref :: http：/ /office.microsoft.com/en-in/access-help/find-eliminate-or-hide-duplicate-records-in-access-HA001034558.aspx [ ^ ]

Hi
选中要避免重复输入的字段的抑制复选框

Hi Check the suppress check Box for the field you want to avoid Duplicated entry