the following is my current Macro in Access 2013. Currently, when I run it, I still have to enter yesterday's date (or last weekday) manually. What would I enter in place of the actual date in the Macro in order to have it automatically run with yesterday's date? Thanks
SELECT [SOM (2)].[Group Date], Sum([SOM (2)].Amount) AS SumOfAmount
FROM [SOM (2)]
GROUP BY [SOM (2)].[Group Date]
HAVING ((([SOM (2)].[Group Date])=#9/23/2015#));