SELECT Customers.Cust_First_Name, Customers.Cust_Last_Name, Customers.Cust_Birthdate, Orders.[Order Date], [Orderlines]![Order_Price_Per]*[Orderlines]![Quantity_Ordered] AS [Order Total]
FROM (Customers INNER JOIN Orders ON Customers.[Customer_ Id] = Orders.[Customer ID]) INNER JOIN Orderlines ON Orders.[Order ID] = Orderlines.[Order ID]
WHERE (((Orders.[Order Date]) Between #4/1/2017# And #3/31/2018#) AND ((Month([Cust_Birthdate]))=4))
GROUP BY Customers.Cust_First_Name, Customers.Cust_Last_Name, Customers.Cust_Birthdate, Orders.[Order Date], [Orderlines]![Order_Price_Per]*[Orderlines]![Quantity_Ordered]
HAVING ((([Orderlines]![Order_Price_Per]*[Orderlines]![Quantity_Ordered])>=1000))
ORDER BY [Orderlines]![Order_Price_Per]*[Orderlines]![Quantity_Ordered] DESC;