I probably posted this before.
We still need to print name badges in the office prior to the event.
Attendees can have multiple guests, with different last names.
When I print my name badges, of course they are in alphabetical order.
In the past I'd have to look at a report that listed the attendee and pull out the guest badges so I could group them together.
Now I use an internal field named sort. I also name it I-SORT so I remember that it is an internal field.
Export all my attendees and guests.
First Name, Last Name, Confirmation Number, Invitee/Guest, Primary Registrant, sort
Sort by Primary Registrant (sort A/Z) and Invitee/Guest (sort Z/A}.
Then number each row beginning with 1 and so forth.
Save to text and import back.
My badge also includes the sort number, usually a small font and gray. Really hardly noticeable unless you are looking for it.
Or if I'm using perfed paper, the sort number later gets discarded.
Once all the badges are printed, I sort the badges by number.
This groups them by attendee.
I have a small event coming up.
I rubberband the groups together for easy distribution since in this case they are all arriving at the same time.
You can do a lot using internal questions.
------------------------------
Steven Schlossman
Jack of all trades. Master of none.
BMW Car Club of America
------------------------------