I have an access report showing a list of appointments in a given month. (those are of course retrieved from a database)

I have appointments on the 1st and on the 3rd of this month. My report's record source retrieves those 2 days with appointments without problem. But what if I want the 2nd day of the month to show even if there's no appointment?

I've been scratching my head a while on this and can't come up with a logical solution. *I could* create a template table with only 31 records (1 to 31), open the report based on that table and manage every day by code, in the report. That MUST be my last resort!

Thanks fellow coders.