Query to pull data with dates greater than 5 days from add date
Having a pickle of a time with this and need some help!
I have created a MSAccess database to track workflow. I need to generate a list that shows all the items that have a status as 'open' and greater than 5days.
START DATE STATUS
2010.06.01 Open (should appear in list)
2010.06.01 Closed (should not appear in list)
2010.06.05 Open (should appear in list)
2010.06.17 Open (should not appear in list, but when I run the report on
06.23, and it's still open, it should then appear).