How to Get Report to Show Date even if Value is Null

[detgharris]

I am trying to create a report bi-weekly to show days worked, but the problem I'm having is that if I have no entry for the two days, it doesn't show the days on the report. I need the off days to be listed also, but just can't figure out how to get there. Thanks in advance.

 

[dhookom]

Consider creating a table/query with all dates and then use a JOIN that includes all records from the all dates table.

Duane
Hook'D on Access
MS Access MVP