Sorting from a newbie

[ams]

I have prepared an extensive table for a 240-member civic league with
additional columns which contain info as to committee membership, board of
directors, block captains, etc. I then wanted a report which only lists the
individuals who hold these offices (about 25 individuals).
But upon sorting, I get the empty columns first and then it sorts by who is
in which committee. How do I do away with the empty cells and only get a
report of the committee members ?

Thanks much,.
ams

 

[John Vinson]

I have prepared an extensive table for a 240-member civic league with
additional columns which contain info as to committee membership, board of
directors, block captains, etc. I then wanted a report which only lists the
individuals who hold these offices (about 25 individuals).
But upon sorting, I get the empty columns first and then it sorts by who is
in which committee. How do I do away with the empty cells and only get a
report of the committee members ?

You're storing data in fieldnames - which is why you're having
difficulty. If you have a Many (members) to Many (responsibilities)
relationship, you need *THREE* tables:

Members
MemberID
LastName
FirstName
<other bio data>

Offices
OfficeID
OfficeName <e.g. "Board of Directors">

MemberRoles
MemberID <link to Members>
OfficeID <link to Offices>
Role <e.g. "Chairman", "Block Captain">

 

[Anna Sargent]

oy Better search for my Access Bible. Been a while.
Thanks, John.
ams

 

[Anna Sargent]

Descending seems a good idea, I can then delete the rest and reverse
the remainder to appear in ascending order.

Ok, where is the criteria line ?

Thanks much,
ams