I need to create a report that will pull back data from ‘last week’, no matter what day of the week management runs it, and management does not want to run a query first so….
Using Iff(Format(Date(),”ddd”)=”Mon”,Date()-3,Date()-1), I’m able to get ‘yesterday’s’ numbers so there has to be a way to do this with last week or last month or even last year. And remember, management does not want to do anything more than push a button for this.
Help!
Copy and paste this to the ‘Field’ line to create a field named ‘WeekNumber’ (note that you will need to enter a table and field name of your date field)
Copy and paste this into the ‘Criteria’ line in the same column
The second field would need to identify the year for each record and filter down to only this year (because there is a 34th week every year 🙂 )
Copy and paste this to the ‘Field’ line to create a field named ‘Year’ (note that you will need to enter a table and field name of your date field)
Copy and paste this into the ‘Criteria’ line in the same column
The Last field will only select working days (Monday-Friday)
Copy and paste this to the ‘Field’ line to create a field named ‘Weekday’ (note that you will need to enter a table and field name of your date field)
Copy and paste this into the ‘Criteria’ line in the same column
Law of Logical Argument: Anything is possible if you don’t know what you’re talking about.