G Guest Jun 24, 2006 #1 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
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 Jun 24, 2006 #2 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.
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.
