Filter and/or sorting question

[Guest]

I have a database of students names, addresses, etc. Many families have more
than one student. I would like my table to display in alphabetical order by
the last name, then within each like address, in alphabetical order by first
name.

Smith, Abbey, 1 Main Street
Smith, Bobby, 1 Main Street
Smith, Aaron, 370 Notmain Road

Can someone explain to me how do I do this, and have the table open up that
way each time?

Thanks,

Max

 

[Guest]

You need to have more than one table and then use a query to display the info
you want the way you want it.

EX: Table 1

Parent Name and Address

Student Name

Link the tables in a one to many relationship
There are numerous posts just this month if you do a search....several very
good MVPs have already written a stepo by step process...one of them for
me..good luck