karatelung
Registered User.
- Local time
- Today, 13:03
- Joined
- Apr 5, 2001
- Messages
- 84
I have a subform that is linked/filtered by ReferralID. Within the subform are fields - FosterID and DateOfAction.
I have a report that is grouped by FosterID and shows me DateOfAction and other information for each client(ReferralID). It would be really helpful if I could show the DateOfAction for the next record that would appear in the subform linked by ReferralID, so I could see when clients(ReferralID) leave a home(FosterID) and come back within the same line of a report.
I guess the field I need in the report needs to first filter the underlying table by the current ReferralID in the report then look up DateOfAction for the very next record sorted by an ascending DateOfAction.
I hope I explained this well enough. Any help is GREATLY appreciated.
Thanks,
Richie
I have a report that is grouped by FosterID and shows me DateOfAction and other information for each client(ReferralID). It would be really helpful if I could show the DateOfAction for the next record that would appear in the subform linked by ReferralID, so I could see when clients(ReferralID) leave a home(FosterID) and come back within the same line of a report.
I guess the field I need in the report needs to first filter the underlying table by the current ReferralID in the report then look up DateOfAction for the very next record sorted by an ascending DateOfAction.
I hope I explained this well enough. Any help is GREATLY appreciated.
Thanks,
Richie
