only show one entry per (1 Viewer)

[stu_c]

Hi all
I want to run a query that when runs only shows words from a specific column but does not show duplicates of words is that possible?
for example if the list was:
BODYWORK
BODYWORK
ENGINE
ENGINE
ENGINE
WINDSCREEN
TYRES

I would like the query to run but only show
BODYWORK
ENGINE
WINDSCREEN
TYRES

I do not want it to delete the records just not show them in that specific query

 

[ebs17]

SELECT DISTINCT FieldX
FROM TableY

 

[stu_c]

thank you!