I have a form with a subform that we use to track participants in our program because we track their participation by month. the main form has each clients name and an ID. The subform contains all the info for each month. Therefore, there are multiple records for each client.
Is there a way to run a query that will show the client's name only once, then the data in each monthly record? I've run a crosstab, but that limits the fields I can look at.
i.e., queries now say:
smith 01/03 yes yes no no no no yes
smith 02/03 yes no yes no no yes no
smith 03/03 no yes no no no no no
But i'd like them to read:
Smith 01/03 yes yes no no no no yes 02/03 yes no yes no no yes no...
Is there a way to run a query that will show the client's name only once, then the data in each monthly record? I've run a crosstab, but that limits the fields I can look at.
i.e., queries now say:
smith 01/03 yes yes no no no no yes
smith 02/03 yes no yes no no yes no
smith 03/03 no yes no no no no no
But i'd like them to read:
Smith 01/03 yes yes no no no no yes 02/03 yes no yes no no yes no...
