Remove/Hide Duplicates from report/query

[Christykvlklm]

I have value in query in a column and single row "H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR". This value I concatenated from different rows by using function. Now I need to remove/hide the duplicate from my access report.

 

[Ranman256]

set the query property to UNIQUE VALUES = TRUE.
no more duplicates.

 

[Christykvlklm]

set the query property to UNIQUE VALUES = TRUE.
no more duplicates.

Still Same.

The Duplicate value in Single cell. Check attached image.