I have a need for a continuous time line report. That is, there must be an entry for every week, even if that entry is zero events.
To accompllish that, I am trying to Make a Right Join Query of a table with the data I need and the week it occurred, with a Table of the Possible Week ending dates.
When I run the query, however, it returns nothing. I used the Access Query designer to create the relationship and the query. I have pasted the SQL below.
SELECT QPR_Interstuhl_QNs_tbl.[WeekEndingDate], QPR_Interstuhl_QNs_tbl.[Total_QNs]
FROM QPR_Interstuhl_QNs_tbl RIGHT JOIN Possible_Week_Ending_Dates_Tbl ON QPR_Interstuhl_QNs_tbl.WeekEndingDate = Possible_Week_Ending_Dates_Tbl.PossibleWeekEndingDates;