If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Reports
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? |
#2
|
|||
|
|||
Access Reports
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 "Holly C" wrote in message ... 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? |
#3
|
|||
|
|||
Access Reports
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 -- Good Luck BS"D "Holly C" wrote: 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? |
#4
|
|||
|
|||
Access Reports
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? "Steve" wrote: 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 "Holly C" wrote in message ... 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? |
#5
|
|||
|
|||
Access Reports
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? "Steve" wrote: 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 "Holly C" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|