keeping duplicates

P

paul

I have two tables, one with publication titles and publication id. another
table with platform and publication id. Some publications may appear in more
than one platform. what i want to find are those publications, but i also
need to know which platforms they appear in, so I basically want to keep all
the duplicates rather than deleteing them. How might i do this?

Thanks!
 
V

vanderghast

You can make two queries, one that group by publication and COUNT (over the
list of publications on platforms) the number of platform. Under the COUNT,
add the criteria >1 (since you want the publications having a count of 2
or more). Save. A second query join the initial table with the query you
just saved. over their common field publication.

Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to set up a query - never used before 1
Using Forms to Providre Critieria for Queries 3
Drop Down Selection for Query 10
Criteria selects data both in and outside user defined date parame 4
Hierarchical cbos to be used in search 21
related tables? - help please! 5
item not found in this collection 1
Creating Lookup 1

Top