I have a report that lists miles for each trip in a day. Any date may have 1 trip, or 2 or 3. I'm trying to get the average of miles by date. In the report embedded on the DataEntry form I want to show the average miles per day as well as total miles. I can easily average all the miles but can't figure out the average for miles per day. For the dates of 7/15 thru 7/19 the average of all miles is 2.54 but by date it should be 4.15. How do I get the average miles bay date? See attached DB