If you think my response was spam that's unfortunate. I have looked at your database and post and do not understand What you are trying to accomplish.
A simple statement like:
We are a small Company who must report Sales of Products to which Customers on a Weekly basis.
That would give readers a hint that you are a business
-with Customers;
-you have Products
-you sell some qty of Product ( to Customers on specific Dates)
-you Report weekly totals. (SalesTotals, possibly Inventory???)
You will find that providing context to your post will help you and readers.
Did you want readers to guess your requirements?
Good luck with your project.
Update: Try this insert into your existing code.
If I have understood the requirement to add Inspector to the criteria then this code should
add the Inspector from the cbo_Inspector to the
strwhere
Code:
If IsDate(Me.txtTo) Then
If strWhere <> vbNullString Then
strWhere = strWhere & " AND "
End If
strWhere = strWhere & "(" & strDateField & " < " & Format(Me.txtTo + 1, strcJetDate) & ")"
End If
'====
If Not IsNull(Me.cbo_Inspector) Then
strWhere = strWhere & " AND Inspector ='" & Me.cbo_Inspector & "'"
End If
'====
'Close the report if already open: otherwise it won't filter properly.
If CurrentProject.AllReports(strReport).IsLoaded Then
DoCmd.Close acReport, strReport
End If
?strwhere
([Data] >= #11/13/2018#) AND ([Data] < #12/01/2018#) AND Inspector ='Hristov'
I hope that's what you were looking for.