Steve Eckerman
asked on
Access 2003 Query
I am working on a query where I want it to look on a rolling 7 day basis. What would the syntax be to make something like this happen. Thanks
als315
There could be different ways. May be you can prepare DB with some sample table and show expected result?
ASKER
Will do.
ASKER
I am working in the attached database called Tooling. In this db is a table called Toolwork and I am using the query called SEW555 History to pull the data from the Toolwork table. I would like to do a rolling 14 day function on the start date column.
Tooling.mdb
Tooling.mdb
ASKER
Going 14 days back from the most current date.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Worked great!!! Thanks!!! I will prepare any future dbs per your instructions.