Go into table design and create a filter. Go to the advanced tab and select the 'Unique Rows' and 'Duplicated Rows-one row only' checkboxes along with the fields that determine "uniqueness" I'd assume it would be ID in your case, but if you want one ID per day rather than one ID in your entire data set, then select both the date and ID columns.
Thanks for your input Chris and Steve, Chris since I wasn't trapping on a report, but utlizing a database, I did utilize the Advanced Tab in a filter scenario to get rid of the duplicates. I had to try a few different scenarios to understand what the filter was doing, but I did get the correct combination. Thank you both!