removal of records with duplicate field value 1

[lobstr003]

Hi,
I'm wondering how I can remove (or hide?) rows of a query when multiple rows have the same information in only one field, not "entirely exact" across all fields. The query is used on a subform, and as I cycle through the entire query, I only need to see one instance of a particular value in a particular field.

I've tried to show totals and then "First" on the particular field that I don't want any repeats, but the query still shows all values in that field, and I think it's because since the *entire* rows are not equal, the query still includes them. I'm using Microsoft Access.

You'd think this would be a simple thing to do... Thanks in advance!

Greg

 

[r937]

use FIRST on all the other fields in the SELECT except the one that repeats, and use a GROUP BY clause for that one

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[lobstr003]

r937,

Wow.. so simple. Makes sense now, I was doing the converse of that... had First on the field I wanted to get rid of dups on and Group By on all the others. Thanks!