I am trying to automate a report and have one last piece of the puzzle. I need to update the criteria for one of my "Make Table" Queries to the previous days date. If I manually put in the date, the query runs properly (pictured here).
However; if I am to use "Date()-1" within the Criteria I receive the error:
I'm open to try any method to achieve updating to the previous day for criteria. Is it possible to have the date within a table pushed to here ? When I tried to do this in SQL, it wiped out all of the links to all of the tables.
Please share any thoughts on how I could accomplish this.