This question may have been asked already so I apologize if I am repeating.
I work for a place that has clients who make multiple visits in a month. I need a query that will show me who has been active in a date range without displaying all of the persons visit dates. Currently this is the SQL strring;
SELECT [CHS-INTAKE].[Participant first name], [CHS-INTAKE].[Participant last name], [CHS-INTAKE].[Related Record1], [CHS-INTAKE].[Related Record2], [sup-parent-detail].[sup-sched-date], [sup-parent-detail].[sup-compl-date]
FROM [CHS-INTAKE] INNER JOIN [sup-parent-detail] ON [CHS-INTAKE].[Participant no] = [sup-parent-detail].[Participant no]
WHERE ((([sup-parent-detail].[sup-sched-date])>=[begin date] And ([sup-parent-detail].[sup-sched-date])<=[end date]) AND (([sup-parent-detail].[sup-compl-date])>=[begin date] And ([sup-parent-detail].[sup-compl-date])<=[end date]));
and i get results like this;
Participant first name Participant last name Related Record1 Related Record2 sup-sched-date sup-compl-date John Doe Jane Doe
4/14/2013 4/14/2013 John Doe Jane Doe
4/7/2013 4/7/2013 John Doe Jane Doe
4/28/2013 4/28/2013 John Doe Jane Doe
4/21/2013 4/21/2013
Where it does give me the name of the client but multiple times because they had multiple visits in the month. All I want is for it show the client's name and related name once in the active date range.
Please help.