Grouping

  • Thread starter Thread starter flusher911
  • Start date Start date
F

flusher911

I have one table with a lot of information where people
have the same last name. I want to group the information
so it only shows the person's first name and last name and
the other information associated with that person. For
example, if I have a Grace Aldrich and a Lorenzo Aldrich
and each person has mutliple records of information, how
do I group the information for Grace under Grace and for
Lorenzo under Lorenzo?
 
First do you have the data normalized? You should have the names in one
table and the data in another where there may be more than one data record
for each person. After that the rest is easy. Without that I can promise
there will be problems.

How is the name recorded now? Do you have a First name field and a Last
name field? If not and if you have only a name field is it 100% accurate
and consistent that it is first name first or are there some last name
first?
 
Back
Top