Eliminating dups for a specific date within a date range

[mark12010]

I have a report that lists Medication date, transaction time, client id and client name. It runs for a date range but is not sorted by date, rather by client name. Lets say I run the report from 8/21 - 8/23 the output should look something like this.
.
.
.
8/17/2010 08:01 AM 199057 ***NAME1***
8/18/2010 08:00 AM 199057 ***NAME1***
8/19/2010 08:03 AM 199057 ***NAME1***
8/17/2010 08:01 AM 199057 ***NAME2***
8/18/2010 08:00 AM 199057 ***NAME2***
8/18/2010 08:05 AM 199057 ***NAME2***
8/19/2010 08:03 AM 199057 ***NAME2***
.
.
.
If you notice for 8/18/2010 ***NAME2*** has 2 entries. This is because teh nurse spilled the first dose and had to re-pour the second. I want to eliminate the second dose as we can only have one dose per client per day.

 

[IanWaterman]

Group your report by Name and then by date, in Date Group dialog box select For each day in bottom window.

Order by date date acending
Suppress details and move all field from details into date group footer.

You will now only see last entry for each day.

If you want to do count/sums use a Running Total and make sure you use distinct or evaluate on change of date group.

Ian