- Joined
- Jan 20, 2009
- Messages
- 1
- Reaction score
- 0
How can I get the weekly query from microsoft access without manually inputting the week dates? We run the report on Saturday or Sunday. The start of the week is Saturday. Currently we are using:
Between #10-Jan-09# And #16-Jan-09#
(we have date and time in separate fields. every week we change this)
What we though of doing was putting:
Between Date()-7 and Date-1
(if we're sending it on a Saturday)
but what if we're sending it on Sunday?
we will need to change it and manually input Date()-8 and Date()-2 again.
I hope someone can help me. Thanks.
Between #10-Jan-09# And #16-Jan-09#
(we have date and time in separate fields. every week we change this)
What we though of doing was putting:
Between Date()-7 and Date-1
(if we're sending it on a Saturday)
but what if we're sending it on Sunday?
we will need to change it and manually input Date()-8 and Date()-2 again.
I hope someone can help me. Thanks.