Weekly query that updates

[Elpis]

Hi
I have made a query that was supposed to update my reports every week with new enquiries that we get.
I thought i had solved this but when i opened the report this morning, it's just showing last week's.
I have this as the criteria:Between (Date()-7-Weekday(Date(),2)+1) And (Date()-Weekday(Date(),2)+1)
It's probably wrong. Can anyone help?

 

[pr2-eugin]

I have made a query that was supposed to update my reports

False ! Queries can update Data in Table, not Reports.

I have this as the criteria:Between (Date()-7-Weekday(Date(),2)+1) And (Date()-Weekday(Date(),2)+1)

This when Translated becomes Between 05/05/2014 AND 12/05/2014

It's probably wrong. Can anyone help?

Probably might be wrong ! Unfortunately, we cannot say so. You need to explain what did you expect the Query filters, what it means it is not working.

Give it another shot in simple English, without code or fancy access jargon; what you need ! Maybe then we will be able to help you out.

 

[Elpis]

I want my query to update every week to show how many enquiries we get in one week. Then to show the results on a report so other people can read it.

 

[namliam]

So you want to show THIS week or LAST week?
or simply the last 7 days?
or what?

i.e.
5/05 - 5/11
5/12 - 5/18
5/09 - 5/15

 

[Elpis]

The last seven days, so 12/5 to 18/5 and then to update the next week 19/5 to 25/5 and so on.

 

[namliam]

last 7 days would NOT include may 18, it is may 16 today... *confused*
What you are describing is THIS week....
which is a small simple change from
Between (Date()-7-Weekday(Date(),2)+1) And (Date()-Weekday(Date(),2)+1)
to
Between (Date()-Weekday(Date(),2)+1) And (Date()-Weekday(Date(),2)+1+7)

 

[Elpis]

Thanks that's worked.
It would include May 18th, Monday to Sunday.

 

[namliam]

yeah but you are executing the query on friday which means sunday hasnt happened yet.