query that doesn't select dupes

[mcnews]

i need a query that identifies dupes, but also allows me to set
criteria to eliminate the dupes i don't want. for example i limit
uniqueness to two fields within a several field row. i may want to
make sure there are no null values in any of the fields in order to
select the best row.
can i do this with a query or do i need to create temp table with
code?
tia,
mcnewsxp

 

[Guest]

A query cannot 'identify dups', it can either return them or eliminate them.
You will have to 'identify' them yourself.
All a query does is to return data that you specify that you want. Once the
data is returned, you decide what to do with it.
By 'eliminate dups' do you mean DELETE them from the table or just not
return them in the query results?
If you want to delete dups, you could create a form that returns the results
of the query, then allows you to mark the ones you want to delete, then via a
command button executes a DELETE query.

-Dorian

 

[mcnews]

A query cannot 'identify dups', it can either return them or eliminate them.
You will have to 'identify' them yourself.
All a query does is to return data that you specify that you want. Once the
data is returned, you decide what to do with it.
By 'eliminate dups' do you mean DELETE them from the table or just not
return them in the query results?
If you want to delete dups, you could create a form that returns the results
of the query, then allows you to mark the ones you want to delete, then via a
command button executes a DELETE query.

i wanted to eliminate the dupes from the result set, but needed some
flexibility in deciding which record to eliminate.
i found a simple way that works for what i need for now.
my need wasn't as complicated as it seemed.
thanks.