G
Guest
I have an event management database with a table that lists a group of
people's names we want to track and whether they showed up. That list is
validated to a list of people on a second table. However sometimes guests
we're not interested in individually tracking show up and we enter their name
into a second field on the event log table, and then enter the validated name
as "Other".
When we want to create an RSVP/CheckIn list we obviously want everyone
alphabetically, but the reports are only sorting on one column, so all the
guests appear under "O" because technically there entry is other.
Is there a way to design a query so that it will properly sort by both
columns, intermingling the second field with the first if it comes up with
"Other"?
Appreciate all the help I can get.
people's names we want to track and whether they showed up. That list is
validated to a list of people on a second table. However sometimes guests
we're not interested in individually tracking show up and we enter their name
into a second field on the event log table, and then enter the validated name
as "Other".
When we want to create an RSVP/CheckIn list we obviously want everyone
alphabetically, but the reports are only sorting on one column, so all the
guests appear under "O" because technically there entry is other.
Is there a way to design a query so that it will properly sort by both
columns, intermingling the second field with the first if it comes up with
"Other"?
Appreciate all the help I can get.