I want to show only the records that have the date from the last 7 days.
the code that i thought i needed was
>=DateAdd("ww",-1,Date())
However when I put this into the criteria for the query it also shows future dates.
Basically i want it to only show sales from the last 7 days (their is...