great, that's what I needed, thank you.

I've got to tell you that calendar is a beauty. I adjusted the SQL statement and it works like a charm, my only concern is that now Im trying to adjust the code to see the count on the boxes along with the information that is alredy there (therapist names). sorry for bothering again but would you please point out the line that populates the squares with the information, or a snippet that will show the count besides the respective name, as it does...

You my friend did a wonder full job, I never thought about doing it in a form style.
thank you so much

Hi, I've been trying for a while now to arrange one of my reports into a calendar layout in access 2003. The current report takes the values of a query made from an intake table which contains the following columns: DateOfService, therapistName. All Im trying to do is to mege those values into a report that has a calendar layout which will only display the name of the therapist and the count of how many times the name appeared in that date. as for...