Thanks for all your replies.
So I have created a form from which I call the report. In the form user can enter date range, which I am passing to the report as an openarg, as shown below.
DoCmd.OpenReport "weekly_report", acViewReport, , , , Me.DateRange & "|" & inspectors
Where Me.DateRange...