group on fields

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have a report that organizes certain information about
students in our project. There are separate fields for the
students' First Names and Last Names. How can I group the
records associated with the students on both their first
and last names? Grouping on Last Name only presents
problems since there are many students with the same last
names.

Thanks
 
Hi Greg,

My name is Dennis Schmidt. Thank you for using the Access Newsgroups.

It depends on how you want the output of your report to print. There are
several ways to accomplish this:

1- Open report in design view, select Sorting And Grouping. Then add
LastName and FirstName as separate sorts. With text boxes in the detail
section, the records will be sorted by both fields.

2- Create a query and a column in the query where you join the two names
together. If you then sort on that column, you will get the desired
results. Column heading would be something like:

FullName: [FirstName] & " " & [LastName]

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Greg said:
I have a report that organizes certain information about
students in our project. There are separate fields for the
students' First Names and Last Names. How can I group the
records associated with the students on both their first
and last names? Grouping on Last Name only presents
problems since there are many students with the same last
names.
Click to expand...

Group on an expression that combines the two names:

=lastname & ", " & firstname
 
Back
Top