Hello,
I created a parameter to be able to enter a number in design view. In my table, I have dates field and a field called numbers. In m parameter, I enter the number 439
It pulls all the times 439 comes out associated with the date the number it came on this is great. However, I now want it to see the number that came 2 days before this numer date and 2 days after this number date
Example I enter 439 and it came on 10/1/2000, 1/2/2006. I want to also see the numbers that came on 2 days before and after these dates as well. I have been away for awhile on duty so my access skills are not the best.
enter 439 it came on 10/1/2000 and 1/2/2006
what number came on 9/30/2000 and 12/31/2005 once i put the number i want to see when i enter 439 in the paramter. Whatever number i enter I want to see what came 2 days before and two days after
Thank you in advance