Query by current and previous date

[mariko]

Hello!

I have a table in access that has weekly data all the way from the beginning of the year. But I only want a query to show the last two weeks of data, not the entire year (current week is last week's data and previous week is week before last). Is there a formula for this that I can enter into the criteria for the date field? I will keep appending weekly data which why I need a formula rather than change the query every week. I hope this makes sense. Any help would be great appreciated!!! Thanks in advance.

 

[Stubby Holder]

hi,

something like

Between Date()-x And Date()-y

where y is the end date & x is the start date required
depending on when you run the query...

eg if you run it the next day you would enter:

Between Date()-15 And Date()-1

or after a weekend

Between Date()-17 And Date()-3

etc

HTH

 

[mariko]

I would run the query after the weekend, so the second equation will work fine. Thank you so much!