Grouping and Alphabetizing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tracking registrations for a family retreat. There is one registration
per family, and each registration is numbered. I now need to alphabetize my
list, keeping families together. I don't know how to keep the family together
when members have different last names. Please help. I am using MS Office
2000.
 
If there is one registration per family then there shouldn't be any issue
keeping a family together. Maybe you could provide some sample records so we
have a better understanding. As another person recently stated "you aren't
being charged by the number of characters in your posts"
 
I'm sorry for the lack of detail. The site has changed since the last time I
used it, and I had only used it twice before. I'm surprised the message was
posted because I received word the posting failed.

Anyway.

The information is being exported from another database. The families have
filled out one registration per family, which is numbered, but each member is
entered individually. So there is more than one record for each numbered
registration.

The table resembles this:

Reg # Last Name First Name Family Position
1 Smith Karen 1
1 Smith
 
Duane,

I'm really not an idiot, just not used to the redesign of the site.

I was trying to give a sample table and was interrupted by a mishap with the
keys.

Reg # Last Name First Name Family Position
1 Smith Karen 1
1 Smith Joan 3
1 Jones Allison 3
2 Barnes Dudley 1
3 Kelly Brian 1
3 Kelly Alicia 2
3 Kelly Ellie 3

Again, I need to alphabetize the list, but keep the families grouped together.
 
I am tracking registrations for a family retreat. There is one registration
per family, and each registration is numbered. I now need to alphabetize my
list, keeping families together. I don't know how to keep the family together
when members have different last names. Please help. I am using MS Office
2000.
Click to expand...

Are you using Microsoft *ACCESS*, one of several programs in the
Office suite? Or Word, or Excel, or one of the other programs?

You will need some unique family ID. If the data that you are
alphabetizing contains only first and last names and registration
information, then there is absolutely NO way that the computer can
recognize that "Jim Smith" and "Mary Jones" are husband and wife. If
the data is in an Access table, or tables, could you describe the
structure of those tables?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
I believe you could create a query
==qselLastName========
SELECT RegNum, LastName
FROM tblSample
WHERE FamilyPosition=1

Then add this query to your existing query and join the RegNum fields. This
will allow you to select the last name of the primary person in the family
for sorting.
 
Since it is a family retreat, why note add a field that shows who they are
related "through" ... whatever "group" you want to make ... simply add that ...
 
Thank you for your assistance. I had to drop what I was doing and move onto
something else, but I am hoping to get back to this soon. Thank you, again.
 
Back
Top