Create a report displaying only one record per day with earliest appointment

I would tackle this with code. I�m not sure about a native solution. I can give you some ideas with a code page leveraging JavaScript if you are interested, but that would be a really technical solution and not one you may be looking for.

Just let me know if that sounds like something you want to do.

Thanks,

~Rob

I would use excel to load up a table with all the dates for the next 10 years.  Set the Key field to be the date field.

Make a relationship to the appointments table based on the [Appointment  date].

Summarize Minimum Appointment Time and call it [First Appointment Time].
  
Lookup [First Appointment Time] down to Appointments.

Since there may be more than one appoint at the same time we know need to loop again to identify just one of the [Record ID#]'s 

New Summary of minimum record ID# subject to the filter that [Appointment timer] is equal to [First Appointment Time].

Call that [Record ID# of first appointment]

Lookup down to Appointments.


Finally, make your report subject to a filter that [Record ID#] = [Record ID# of first appointment]

If you were trying to only display the first appointment of only one day and not multiple days it wouldn't be hard to do. Given your example of multiple days you would need to use Mark's native solution or go with scripting.