SQLTeam.com | Weblogs | Forums

Working in access 2013 need help with parameter

access

#1

I would like to create a parameter within my design view that when I hit run and the query brings me back my date with the number I enter as my parameter. I would like to see 2 days before and 1 day after. For instance, If I enter 801 as my number and that number came on 8/1/2016, and 7/2/2015. I would like to see the number and the dates for the number that came on 7/31/2016 and 7/30/2016 and 8/2/2016, 2 days before and 1 day after a number I enter as my parameter. Thank you for your assistance