Joined: 21 Aug 2017
Location: United States
Online Status: Offline
Posts: 39
Topic: Duplicates due to multiple dates Posted: 31 Aug 2017 at 6:00am
Hello forum
So I'm trying to report clients who have received an assessment in the past 3 years. My problem is that clients are being reported more then once if they've received more then one assessment. I'd like for it to only report the latest assessment. Example of what it looks like now:
156 clinician name 5/25/17
123 clinician name 1/2/16
123 clinician name 4/15/17
889 clinician name 10/20/15
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 31 Aug 2017 at 6:10am
Group by date and put the fields in the group footer and hide the group header and the details (grouping by date will put the dates in ascending order, thus the latest date will be in the group footer).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
