Calculating totals in a report

[LaughingBull]

I have a table of contacts and a table of attendance to meetings. The same person can attend more than one of the different meetings. I have to calculate the total number of people who attended all the meeting for one year then I have to query duplicates I have done this my question is I want to create a report using the attendance query and the duplicate query so I can subtract the total duplicates total attended. so if 100 people attended all the meetings and 3 of those people had 3 duplicates for a total of 9 duplicates but I need to enter those 3 people once each as the total so there is 9 dup but it was for 3 people so if the total so 100 then I need to subtract 6 repeats. any suggestions of a way to accomplish this. I do have skype (ltjv123)


I don't see how to make a report from 2 different queries and I am unable to make a third query with the existing 2 queries it says they are not linked.
I also ran a report on the duplicate query and tried to subtract the record count from the total duplicates but I was unable to come up this the correct formula.

[LaughingBull]

I figured it out. in properties select the ID and under format select yes under hide duplicates then do an count of ID and it only counts the ID's that show on the report.