How do I hide repeated result in queries in Access

[John W. Vinson]

It's considered polite to use the big white textbox to post your question, not
just the subject line.

But to answer... you can't. You can exclude them from the query completely;
view the query's Properties and set it the "Unique Values" property to Yes and
it will display all rows that are EXACT duplicates as one row. Or, you can use
a Totals query grouping by a set of fields to show all members of a group as
one row.

 

[John Spencer]

You might use the big white space to give us a more complete idea of
what you want to do.

It may be as simple as setting Unique Values for the query to YES. Or
it may be much more complex.

-- Open query in design view
-- DOUBLE_Click on blank space in the upper section of the design view
-- You should get a dialog box of properties
-- Find Unique Values and change the value to Yes
-- Run the query and see if it now displays what you want it to display.

If not, post back here with more information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Cathy wrote: