thanx for helping me out.
here is the db attached.
goto the form: Customer Orders By Customer Report. then there is only one customer Jerry. put date from 1 jan 2023 to Today. then the report ll populate I am having problem in.
T
thanx Doc. Here is the code...
FROM [Customer_Orders Query]
WHERE ((([Customer_Orders Query].Order_Date) Between [forms]![Customer Orders By Customer Report].[begdate] And [forms]![Customer Orders By Customer Report].[enddate]) AND (([Customer_Orders Query].Customer_ID) Like...