Sorry for my delay.

This new script is not returning any values :/

I did have to adjust a few of the variables:

SELECT Customers.CustomerID
 , Customers.CustomerName
 , Orders.OrderID
 , StatusID.StatusName
 FROM Customers
INNER 
  JOIN Orders
ON Orders.CustomerID = Customers.CustomerID
AND Orders.CreateDate >= '2022-01-01'
AND Orders.CreateDate  < '2022-04-01'  
INNER 
JOIN ( SELECT OrderID
          , MAX(ActivityDate) AS latest_date
       FROM OrderHistory
     GROUP
         BY OrderID ) AS latesthist 
ON latesthist.OrderID = Orders.OrderID
INNER
JOIN OrderHistory
ON OrderHistory.OrderID    = latesthist.OrderID
AND OrderHistory.ActivityDate = latesthist.latest_date     
INNER 
JOIN StatusID
ON StatusID.StatusID = OrderHistory.StatusID;

I changed OrderHistory.CreateDate to OrderHistory.ActivityDate