Access question

[thecremeegg]

I have an access query and i want it to only return dates in the next week and i've put in the criteria box ">date() OR <date()+7"
But it doesnt work, it just shows all results still, the filter doesnt apply.
Any ideas?

 

[DougClio16v]

You can use between the date and the first date and the last date.

 

[172.com]

If you're querying a DB then you're not actually specifying which column you're querying.

WHERE [column name] between 20071128 and 20071205

 

[172.com]

Also, if you want dynamic dates you could use

between getdate() and dateadd(wk, 1, getdate())

 

[thecremeegg]

Thing is it applies one filter but not both if you get me?
If i put less than todays date + 7 (<date()+7) then it works. Thing is i only want it to show records between now and next week and it doesnt like to do this. Why is it only applying one filter?