By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Some easy help

P: 5
Hello-

Looking for help. I'm still an extreme novice.

Would like to create SQL to capture all dates that are 10+ days older than a stated date.

So, essentially

Would make it a LOT easier than trying to back count on the callendar. Looking for reports that remainb unresolved after they age 10 days.

Any help would be greatly appreciated. let me know if my description is not clear enough.

thanks
-j
Sep 13 '07 #1
Share this Question
Share on Google+
1 Reply


MGrowneyARSI
P: 90
in your qery what ever the date field is drop it down into the query 2 times then do somthting like this <[Forms]![Dates_Form]![Date1] in the critiria for the first one and like this >[Forms]![Dates_Form]![Date1]-11 for the second one that way what ever date is in the field you use to select it will limit the query or SQL to look at the ten days prior to I created and tested this so it will work let me know if you have any issues
Sep 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.