Easy - Access report question

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.

not sure what version you are using, or if this will be of any help, but have you thought about or are you using something like ARPRINCE posted for your print routine ?
http://www.vbforums.com/showthread.p...hreadid=235961

you could then loop through the actual record selection, based on a previous "select case" ? for the number of days in the month?

i.e.
Select Case Month
Case "January"
Days = 31
Case "February"
Days = 28 (and maybe something for leap year)
---etc-----
End Select

Then you could print for each date, the appointments, and if there were no records, you could simply print " " (a space).

Not sure if this is the most correct way of doing it, but it would keep from having to add a table, as you suggested.









:D