can I state criteria within a report to eliminate duplicates?

H

HGood

Hi, I have a many to many relationship database where a Project can have
multiple languages in it, but a language can also be involved in multiple
Projects.

I have a report driven by a query. The query needs to allow these 'languages
involved in muliple projects' through, because they are valid, but they are
fouling up my report grouping, appearing twice in a given Project grouping,
instead of once.

This is what's appearing on my report (grouped on the left column):
Project A Language 1 involved in Project A (correct)
Project A Language 2 involved in Project A (correct)
Project A Language 2 involved in Project B (this is the unwanted double)
Project B Language 2 involved in Project B (correct)
Project C Language 3 involved in Project C (correct)

Is there some way for me to state criteria in the report so that the ID for
column 3 must match that of column 1 in order to appear in this group? Would
this criteria be stated in a control box?

Thanks for any help you can give,
Harold
 

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

not count duplicates in report group 2
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
HOW CAN I COUNT ALL THE GROUPS IN A REPORT 0
automataic creation of report using a template 1
Report Control Source 1
Query Difficulty 9
Help with a Monthly Summary Report 3
Problem with duplicates in Access 2003 0

Top