Using Yesterday's Date as Criteria for a Report 1

[jeremyhache]

I'm new to Access and sql so how would I use yesterday's date in MM/DD/YYYY format as criteria for a report in Access 2000?

I'm trying to edit an existing report that prompts for the date but I need a version of this that I can have a batch file run daily, so it can export an .snp version to my company's intranet, therefore, I can't have Access prompting for the date when it tries to run the report. (Sorry the backround info is so lengthy and uninteresting

 

[SJG0526]

Does this help?

format(now() - 1, "mm/dd/yyyy&quot