Eliminating duplicate fields in a query

[nate_03]

I have a table with 8 entries which repeat over and over again (Monitor Make)

I am trying to create a query that eliminates all of the repetitive entries, so instead of displaying 250 of the same Monitor Make I would like it to just display the 8.

Simply put, I would like to eliminate the duplicate fields in my query.

What do I have to put add to the criteria in the query design?

nate

 

[AncientOne]

In design view, right click above the grid, select properties and set "Unique Records" to Yes

 

[Pat Hartman]

I can't tell by your question whether you want just 8 rows returned, in which case AncientOne's solution is what you are looking for or if what you are asking is "how to hide duplicate fields" in a query. The answer to that is - you can't. Use a report that hides the duplicates.

 

[nate_03]

Yes Pat I wanted to hide the duplicate fields but I guess thats not possible.

Thanks for all your helps guys!