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

How can the font and size of (all) citation numbers be altered? 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
List all tables, including document structure 0
VBA word change keys 0
Automatically insert "Continued" in footer based on existing STYLEREF 2
Duplicate records suppressed 7
Create a distinct Join 3
Using the list form control: multi-selection possible? 3

Top