Show last weeks fields

[Zholt]

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 some example data that has future dates that i do not want to be shown)

 

[ajetrumpet]

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 some example data that has future dates that i do not want to be shown)

the query is RIGHT. " >= " means "records that have a date newer than -7 days from now. use BETWEEN. like this:

between dateadd("d", -7, date()) and date()

]

 

[Zholt]

Works a charm thank you V much