find unique items (1 Viewer)

[alienscript]

Hello Access experts,

I try using query below to find the unique items in a Field but it doesnt work. Can someone help me with this query?

Thanks very much in advance.

In (SELECT [project_item] FROM [Table1] As Tmp GROUP BY [project_item] HAVING Count(*)=1 )

 

[Moniker]

SELECT DISTINCT [project_item] FROM [Table1];

 

[alienscript]

Thank you very much