I have been requested to run an automated query that runs once a week, for example on a Monday. The query needs to extract the data for the last 7 days. For example the date range for the first monday would of been 1 jan - 7 jan, the next time it runs the date range needs to be from 8 Jan - 14 Jan etc. The date select needs to be done without using the parameter query. The info is then displayed on a TV screen for the sales people to view.
Thanks you for your assistance