Query Duplicate fields, but want to show each once

[msouriya]

Ok, so I have two tables that I've joined together to create a query. My query is such that it has student names in table 1 and table 2 has services. I want to query out each a student's name once even though they more than one services. I just want to know if the students received services at all, so that's I just want each student's name to show up, but I'm getting duplicate of student's names. Below is my design. I hope that makes sense, please help me!!

[pbaldy]

Click on the Totals icon, change the services field to Count from Group By and see what that gives you. Your design didn't come through by the way.

[msouriya]

It didn't work. :-( Below is my design.

[pbaldy]

Well, you've asked for a bunch of information from the services table, so you're going to get it. If all you want is to know that there were services, do what I described but drop all the fields from the services table but the first 2. Change the grouping row to Where on the date field and Count on the Service field.

[msouriya]

Good evening, thank you for your help. However that won't work either. I prompted that there was conflict. Please see image below:

[pbaldy]

Can you post the SQL of the query?

[msouriya]

SELECT DISTINCT StudentTBL.TSID, StudentTBL.StudentIDNumber, StudentTBL.LastName, StudentTBL.FirstName, StudentTBL.Grade2021, StudentTBL.SecSchool2021, StudentTBL.MInitial, StudentTBL.PEA2021, [Services Received TBL].DateOfService, [Services Received TBL].Service, [Services Received TBL].SubService, [Services Received TBL].ServiceComments, [Services Received TBL].Contact_Time, [Services Received TBL].ServiceID
FROM StudentTBL INNER JOIN [Services Received TBL] ON StudentTBL.TSID = [Services Received TBL].TSID
WHERE ((([Services Received TBL].DateOfService) Between #9/1/2020# And #8/31/2021#))
ORDER BY StudentTBL.LastName, StudentTBL.PEA2021, [Services Received TBL].DateOfService, [Services Received TBL].Service;

[pbaldy]

You don't appear to have tried my suggestion involving the Totals icon. Can you attach the db here so I can show you?

[msouriya]

Thank you for your assistance! I figured it out.

[pbaldy]

Glad you got it sorted.