Date in access

[clarkproperties]

How do you change the year 2020 to current year



TRANSFORM Sum(CCur([Order Details].[UnitPrice]*[Quantity]/100)*100) AS ProductAmount
SELECT Products.ProductName, Orders.CustomerID, Year([OrderDate]) AS OrderYear
FROM Products INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID
WHERE (((Orders.OrderDate) Between #1/1/2020# And #12/31/2020#))
GROUP BY Products.ProductName, Orders.CustomerID, Year([OrderDate])
PIVOT "Qtr " & DatePart("q",[OrderDate],1,0) In ("Qtr 1","Qtr 2","Qtr 3","Qtr 4");

Thanks in advance

Steve

[Bob Fitz]

Try:
WHERE (((Orders.OrderDate) Between #1/1/Year(Date)# And #12/31/Year(Date()#))

[Welshgasman]

Try:
WHERE (((Orders.OrderDate) Between #1/1/Year(Date)# And #12/31/Year(Date()#))

Bob, wouldn't we need & in there?

[CJ_London]

alternatively

WHERE Year(Orders.OrderDate)=Year(Date())

[clarkproperties]

thank you all i got it