How to remove duplicate frpm query

[dinesh010595]

[ssanfu]

Not a lot to go on.......

Try this:
Open the query "ControlFile Query" in design view
Switch to SQL view.
Add the word Distinct after SELECT....... see below

Select DISTINCT Field1, field2,.......FROM.....

Save the query.
Execute the query......