Not seeing dupicates in Report

[Guest]

The school I work for has a report that we run at the end of every school year. I have been asked to modify this report to sort by lastname. I have tried using the sorting and grouping option of the form to sort by last name but lose alot of people that way. I will only see 1 instance of each last name. For example, If there are 5 Smiths and 10 Adams in my school, after I run the report, i will only see 1 Smith and 1 Adams. I have tried altering the query that the report is based on. When I run the query, I can get this sorted right with all records but still can't get report to run right. Thank you in advance for any help you can give me.

 

[Marshall Barton]

The school I work for has a report that we run at the end of every school year. I have been asked to modify this report to sort by lastname. I have tried using the sorting and grouping option of the form to sort by last name but lose alot of people that way. I will only see 1 instance of each last name. For example, If there are 5 Smiths and 10 Adams in my school, after I run the report, i will only see 1 Smith and 1 Adams. I have tried altering the query that the report is based on. When I run the query, I can get this sorted right with all records but still can't get report to run right. Thank you in advance for any help you can give me.

It sounds like you have the data in the last name group
header or footer. You didn't say you wanted a grouping so
you would not want a header/footer and the controls should
be in the detail section.

 

[Fons Ponsioen]

I would suspect that each student is assigned a StudentID
in the database. Waht you should do is sort on the
lastname and firstname and the student ID, this will
ensure that you will create a separate record for each
student. Now in you report you may have to look as the
hide duplicates property for the lastname and firstname
texboxes.
If this does not resolve the issue please post back with
more specifics.
Fons

-----Original Message-----
The school I work for has a report that we run at the end

of every school year. I have been asked to modify this
report to sort by lastname. I have tried using the sorting
and grouping option of the form to sort by last name but
lose alot of people that way. I will only see 1 instance
of each last name. For example, If there are 5 Smiths and
10 Adams in my school, after I run the report, i will only
see 1 Smith and 1 Adams. I have tried altering the query
that the report is based on. When I run the query, I can
get this sorted right with all records but still can't get
report to run right. Thank you in advance for any help you
can give me.