I want to display an attendance register for each day in a month (01 thru 31) in a report.

SQL table has only one field of date for which present is registered. (Date for which preson absent is not stored in table)

But  I want to show these absent dates along with  present dates in sequence starting form 1st of month up to last

 

If any one know the trick please help me

Thanks in advance