Skip to main content
Question

need to identify and eliminate duplicate records from combination of 2 different fields in a report

  • April 10, 2019
  • 0 replies
  • 41 views

I have two tables: 1. Meetings, 2. Clients, the relationship between the two tables is one to many.
So multiple meetings can be done with one client. and multiple people can setup the meetings with same client.

I am creating a report in the meetings table where i want all total unique list of meetings i.e. only one record of "meeting person + client".

I have achieved the list of all the meetings but the problem is i am getting multiple records.

for example:
what i want is 
meeting person 1 + client 1
meeting person 2 + client 1
meeting person 3 + client 1
meeting person 1 + client 2
meeting person 2 + client 2
meeting person 4 + client 2


------------------
but what i have achieved is:
meeting person 1 + client 1 (meeting 1)
meeting person 1 + client 1 (meeting 2)
meeting person 1 + client 1 (meeting 3)
meeting person 2 + client 1 (meeting 1)
meeting person 2 + client 1 (meeting 2)
meeting person 3 + client 1 (meeting 1)
meeting person 1 + client 2 (meeting 1)
meeting person 2 + client 2 (meeting 1)
meeting person 4 + client 2 (meeting 1)
meeting person 4 + client 2 (meeting 2)
meeting person 4 + client 2 (meeting 3)

I hope this makes sense.
This topic has been closed for replies.

Have you you tried a Summary report and Group by Meeting Person and then add a Group by Client.