S
StargateFanFromWork
I need to create a report for my team. I'm running out of time in my
contract and my supervisor hasn't had a chance to do this, so I need to take
care of this for them myself as it may take too long a time to complete
otherwise.
We have a form that has a subform that tracks correspondence. Though the
"history" shown in the subform is necessary, we only require that the last
entry out of the subform appear for each record. This entry has the
recordID of the main form, an employee name field and a status field. The
employee field shows to whom the docket was assigned to so we know where
each docket is at any given moment, even if only in theory! <g>
So the report needs 2 things from the form / tracking subform:
1) It needs to show all records assigned to each person on the team.
Therefore, the report will need to be grouped and sorted by employee with a
page break in between names so that we run only the one report but can
easily hand out the individual pages pertinent to each person (from the last
record in the tracking subform);
2) Info re the docket (form); and
3) The status of each docket (from the last record in the tracking
subform).
This seems like such a tall order to me as I haven't a clue where to start.
However, my boss has mentioned that she did this type of thing elsewhere
using a query of a query of a query, or somesuch. Can anyone point me in
the right direction so that I can start doing research on how to do this?
I'd really appreciate it, as well as my team!
D
contract and my supervisor hasn't had a chance to do this, so I need to take
care of this for them myself as it may take too long a time to complete
otherwise.
We have a form that has a subform that tracks correspondence. Though the
"history" shown in the subform is necessary, we only require that the last
entry out of the subform appear for each record. This entry has the
recordID of the main form, an employee name field and a status field. The
employee field shows to whom the docket was assigned to so we know where
each docket is at any given moment, even if only in theory! <g>
So the report needs 2 things from the form / tracking subform:
1) It needs to show all records assigned to each person on the team.
Therefore, the report will need to be grouped and sorted by employee with a
page break in between names so that we run only the one report but can
easily hand out the individual pages pertinent to each person (from the last
record in the tracking subform);
2) Info re the docket (form); and
3) The status of each docket (from the last record in the tracking
subform).
This seems like such a tall order to me as I haven't a clue where to start.
However, my boss has mentioned that she did this type of thing elsewhere
using a query of a query of a query, or somesuch. Can anyone point me in
the right direction so that I can start doing research on how to do this?
I'd really appreciate it, as well as my team!
D