Evi said:
There is still something that isn't clear in what you are saying I don't
understand what you mean by 'parsed down to a readable form' . What exactly
do you want to see (give an example). Do you want it to be in a query, or in
a report?
I mean i have 30 fields for each individual, and in order to compose an
invite list, my boss only needs to see the names and their current invitation
status (5 fields).
How do you deal with people who have more than 1 affiliation? From your
sample, it is clear that that one person can be both a Family member and
retired and possibly in government too (after watching the House of Lords in
Yesterday In Parliament!)
Since each person needs only to be reviewed once, more than one affiliation
is not required. Each person is given an affiliation with the highest value,
for example a Family Member will trump any other Affiliation, VIP will trump
any other affiliation EXCEPT Family, Personal friends will trump any other
Affiliation EXCEPT Family & VIP, etc., etc., and so on.
Do you have one table listing the various affiliations available, one
listing the people and one linking the people with however many affiliations
they belong to? If not, your data could end up as illogical.
If you design your db correctly you won't need to split the data up into
different queries, you could put the whole list in 1 report, use the
SortingGrouping button to Group by Affiliation with a header and footer, add
a runningsum textbox to the number items in each group and add a text box to
the group footer with
=Count(*)
typed into it.
I wish I could print the entire database, but unfortunately 82-ytear-old men
can't work with that amount of information.
Thus, I am narrowing fields down so that he can easily think about ONLY
Friends, Family, or VIPs, etc. This way, he may only have to go through 100
or so names in each affiliation, instead of the 2000 name list I currently
have.
It is illogical to print a list of 2000 names anyway, for a man or woman of
any age.
.. If you want a sequential number field in a query to act as a kind of row
counter, have a search in this group for Karl Dewey's post on Ranking (RANK)
in a query..
Evi
Thanks! Will do.
Char