Search results

Wow! Thanks Khawar!!! I actually found a method using a ranking but your version is much cleaner. Thanks again!

Hi all, I'm relatively new to Access and had a question that doesn't seem so simple to me. I need to create a query that will take the rolling 3 month average of my value fields. The date option will remain dynamic for the user so date ranges could range between 3 months to 2 years. Here...