Automate a date field

[simon4amiee]

Hi guys, wondered if there is way to simplify this.

I run a query daily and have to alter the date in the design view (as below).

>=#01/04/2013# And <#11/03/2014#

All I want is for the query to run 2 days behind, so for example today is the 12/03/2014, I use the above, and then daily change this every day.

 

[namliam]

Something like so....???

>=dateserial(year(date())-1, month(date())+1, 1) and <= date() -1