Access Reports

[Holly C]

I am creating a board of directors list. I want the President, Vice
President, Secretary, Treasurer to be listed first in the report,
alphabetically which I can do, however I would like all the Directors listed
after the Executive. How do I do this?

 

[Steve]

Suggest you have a board of directors table:
TblBoardOfDirectors
BoardOfDirectorsOD
Office
SortOrder

Table records would look like:
1 President 1
2 Vice President 2
3 Secretary 3
4 Treasurer 4
5 Director 5

List the people in these offices using a query that includes
TblBoardOfDirectors. First sort by SortOrder ascending then alphabetically
by last name. Sorting by SortOrder puts Directors after Executive.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Ofer Cohen]

I had a similar situation,
I create a sub report that listed all the names (I used it in few reports),
and I added another field to the table that state the priority for each group
of people, and then sorted the sub report
First sort - The priority field
Second sort - alphabetically by name


For this example I have two tables:

Employees Table = added another field to the table (GroupNum)
Groups Table = GroupNum, Description, Priority

 

[Holly C]

Hi Steve, thanks for your reply. I am pretty new at access and if you have
the time...would appreciate more details. Do I create 2 tables?

 

[Holly C]

Steve I have tried everything, sorry, I cannot get this to work. I can see
how it should but it does not. I will explain my form...I have a form that
lists units, the owner of these units, address, phone, etc From this group
of owner units is elected a board. On the form (which is made from a query
called All Unit Info, which is built from a table called Unit Info), I want
to have a place where I can go to a drop down and click president on the
president's unit and vice president on the vice president's unit. I cannot
get the combo box to show the BoardofDirectorTable.

Can you help me?