Designing query to only show unique records

Hi

I am trying to get the results of a query to show only unique student
records (not duplicates). Is there a simple way to make the criteria
field do this? I am not too familiar with SQL.

I have a student_info table, a session_info table, and a
services_to_students table.
What I'd like to do is query the tables to get a list of all students
served between certain dates. Now, of course, between those dates,
any given student has been served more than once, so without
eliminating duplicates, a given student (tracked by a unique
student_record) will show up repeatedly.


Any ideas? Again, I know it's pretty simple, but I can't seem to do
it.
Any help is appreciated.

.

Relevant Pages

  • Re: Cumulative cost
    ... When you say "running total per student", I believe this means the same ... You can use a Totals query to get a "per student" Sum ... AND calculate something you're calling "cumulative cost". ...
    (microsoft.public.access.forms)
  • Re: Searching for and editing a record in form view
    ... I've created a query but I was a bit unsure of this, ... different from the StudentID for any other student. ... So I've done what you said, went to the switchboard, highlighted the combo ... This one opens the form to a specific record. ...
    (microsoft.public.access.forms)
  • Re: After School Attendance
    ... run a query for a reporting period, ... attendance somewhere so we can run queries and reports for a given time ... What does the "select student" in the header do? ... and it would very time consuming to create a roster each site. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Deleting records
    ... Query1: a query to select the distinct Items: ... "Jim Jones" wrote: ... The first 2 fields identify the student uniquely; ...
    (microsoft.public.access.queries)
  • Re: Duplicating Data
    ... Why would you want to place these three tables in the same query? ... student has one record in the student table, ... Normally the attendance and/or assignment tables would be displayed ... > I have an 11 table Database all relating to "Student Information" SSN ...
    (microsoft.public.access.tablesdbdesign)