Question Including a count at end of category in list box

[josephbupe]

Hi,

Given the following tables:

T_Personnel
PersonnelID=PK
Family Name=text

T_Divisions
DivisionID=PK
DivisionName=txt

T_Stations
StationID=PK
StationName=txt

The three tables above are linked as follows:

T_PersonnelTransfers
TransferID=PK
PersonnelID=FK
DivisionID=FK
StationID=FK

How can i add a total number of Persons under a given Station so that the number appears in blankets at the end of each Station in a list box?

Joseph

 

[tad0075]

Could you set up the source of the list box as a query with the personnel count included? Should be able to inner join PersonnelTransfers with Stations, group on StationID and/or StationName, then count PersonnelID.

 

[boblarson]

Hi,

Given the following tables:

T_Personnel
PersonnelID=PK
Family Name=text

T_Divisions
DivisionID=PK
DivisionName=txt

T_Stations
StationID=PK
StationName=txt

The three tables above are linked as follows:

T_PersonnelTransfers
TransferID=PK
PersonnelID=FK
DivisionID=FK
StationID=FK

How can i add a total number of Persons under a given Station so that the number appears in blankets at the end of each Station in a list box?

Joseph

you can do a query for the counts and then add it in with the postbox row source linked on StationIF.

SELECT StationID, Count (StationID) As StationCount
FROM T_PersonnelTransfer
GROUP BY StationID