31 day rows

P

Please help me..

I need to make a report that shows 31 day rows and place dates even though
there is no data for those dates:
Exp.
1 6/1
2
3 6/3
4
 
D

Douglas J. Steele

Have a table that contains the numbers 1 through 31.

Join that table to the table that has data in it using a left join, and
comparing to the Day of the date field in your data table.
 
Top