Query to hide duplicate records

[Jim Helfer]

I recall that this used to easy in previous versions (Unique values
only ??), but in 2007, I can't get this to work at all.

I have a table with our companie's job numbers in it. The job numbers
show up multiple times because of different phases of the project:

ProjNum ProjDescription
3077 Univ. of Vermont/UC/LEED
3077 Univ. of Vermont/University Commons: Building Fee
3077 Univ. of Vermont/University Commons: Excess Professiona...


I need to jut have a single listing of each project number, otherwise, I
get repeated records in the query that looks at this information (which
of course, causes a bad report).

I'm following the section on duplicate records in Help, but none of
it's instructions are working for me. The result is always all the records.

 

[Jeanette Cunningham]

Jim,
Create a query with one field only - ProjNum.
In query design set Unique Values to Yes.
If you include the field ProjDescription, you will get the results you
posted.

Jeanette Cunningham