Sorting from a newbie

  • Thread starter Thread starter ams
  • Start date Start date
A

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
 
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 ?
Click to expand...

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">
 
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
 
Back
Top