Filter a Query

  • Thread starter Thread starter sturner333
  • Start date Start date
S

sturner333

I have a query that one of the fields can have repeated values because it is
repeated in the table it comes from. I would like to only have one of the
repeated fields.
For example:

1000 1330 Bob Lowman 1330
7000 7110 Steve Quast 7110
7000 7110 Steve Quast 7110
7000 7110 Steve Quast 7110
7000 7120 Steve Quast 7120

I would like:

1000 1330 Bob Lowman 1330
7000 7110 Steve Quast 7110
7000 7120 Steve Quast 7120

Thanks for the help!
 
Hi,
you might be able to achieve this by going into the query properties dialog
and choosing Yes for Unique Values

If the above won't work with your query then:
Create a separate query with just this field and in the query properties
dialog, choose Yes for Unique Values.
Use this new query to join to your existing query in place of the field that
has the repeated names.

Jeanette Cunningham
 
Back
Top