BC_Seattle
Registered User.
- Local time
- Today, 02:58
- Joined
- Jun 18, 2019
- Messages
- 24
I have inherited a database and we currently have a query that pulls all invoices that were completed last week. I wanted to add another report that does the same thing for the last 4 weeks starting as of today. This will help audit anything missed. The code I have appears to only use Static weeks and am not sure how to range or count backwards 30-45 days from today's date and pull those invoices.
So you can see what I have to work with any help is appreciated. I am an Access Noob and just trying to learn things as I go so please be gentle.
Here is what I have in the Data Tab under Filter:
(Year([Billing Last Week].[Invoice Date])*53+DatePart("ww",[Billing Last Week].[Invoice Date],0)=(Year(Date())*53+DatePart("ww",Date(),0)-1))
I have determined the last -1 determines what static week to pull from but I would like to have multiple weeks just unsure how it needs to be coded.
So you can see what I have to work with any help is appreciated. I am an Access Noob and just trying to learn things as I go so please be gentle.
Here is what I have in the Data Tab under Filter:
(Year([Billing Last Week].[Invoice Date])*53+DatePart("ww",[Billing Last Week].[Invoice Date],0)=(Year(Date())*53+DatePart("ww",Date(),0)-1))
I have determined the last -1 determines what static week to pull from but I would like to have multiple weeks just unsure how it needs to be coded.