Re: Designing query to only show unique records
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Thu, 28 Jun 2007 15:34:43 -0500
kdubble wrote:
That didn't work:
here's my SQL view
SELECT DISTINCT Student_Info.Student_Record, Student_Info.Grade,
Student_Info.SchoolName, Session_Information.Counselor,
Session_Information.Date, Student_Info.[Student Last]
FROM Student_Info INNER JOIN (Session_Information INNER JOIN
Services_To_Students ON Session_Information.[Session#] =
Services_To_Students.[Session#]) ON Student_Info.Student_Record =
Services_To_Students.Student_Record
GROUP BY Student_Info.Student_Record, Student_Info.Grade,
Student_Info.SchoolName, Session_Information.Counselor,
Session_Information.Date, Student_Info.[Student Last]
HAVING (((Session_Information.Counselor)<>"All Counselors" And
(Session_Information.Counselor)<>"Paid Tutor/counselor") AND
((Session_Information.Date) Between #7/1/2006# And #6/27/2007#));
my results show each individual service that a given student_record
receives. I just want to show how many students got serviced in a
date range.
DISTINCT will work if you don't include any fields from the
Session_Information table in your output.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- References:
- Designing query to only show unique records
- From: kdubble
- Re: Designing query to only show unique records
- From: ManningFan
- Re: Designing query to only show unique records
- From: kdubble
- Designing query to only show unique records
- Prev by Date: linked tables in 97 version not showing up in 2003
- Next by Date: Re: Designing query to only show unique records
- Previous by thread: Re: Designing query to only show unique records
- Next by thread: Re: Designing query to only show unique records
- Index(es):
Relevant Pages
|
