Hey all, long time reader and first time registered poster! Everyone here has been very helpful solving some interesting problems but I can't seem to find a solution for this one.
I am using Access as a very basic meeting manager/template generator for projects. I was able to create some great looking agenda items but I would like to include the last weeks notes in the agenda moving forward.
Each agenda item is on its own table and (AgendItems) and the updates are another table (AgendaItemUpdate) linked by the AgendaItemID. What I am trying to do is show the latest/last record only in the AgendaItemUpdates table based on that AgendaItemID. There are multiple AgendaItems on a meeting template and I would like the report to show the last record for each item.
When I created a subform, it showed all the updates for the AgendaItemUpdates and not the latest one. I also tried filtering by Top results and it seems to only apply for the most recent items leaving the others blank.
Any assistance on how to limit a Report Subform to only show the last record for each parent item?
Many thanks!
I am using Access as a very basic meeting manager/template generator for projects. I was able to create some great looking agenda items but I would like to include the last weeks notes in the agenda moving forward.
Each agenda item is on its own table and (AgendItems) and the updates are another table (AgendaItemUpdate) linked by the AgendaItemID. What I am trying to do is show the latest/last record only in the AgendaItemUpdates table based on that AgendaItemID. There are multiple AgendaItems on a meeting template and I would like the report to show the last record for each item.
When I created a subform, it showed all the updates for the AgendaItemUpdates and not the latest one. I also tried filtering by Top results and it seems to only apply for the most recent items leaving the others blank.
Any assistance on how to limit a Report Subform to only show the last record for each parent item?
Many thanks!