Please help this Access class is killing me

[NovicetoAccess]

Hello Access Forums,
I heard about your site from a few of my classmates. I am totally new to Access and I am trying. I have two tables within my database. The first table has numbers for each date for the last ten years Ex. 490 was on 7/1/2013. I want to be able to see what 2 dates and 2 days after a number/ Ex. If 490 was on 7/1/2013. I want to be able to see the number that came two days before 7/1/2013 and 2 days after 7/1/2013. So if 490 came on 7/1/2013 I want to see the number that came on 7/29/2013, 7/30/2013 and 7/2/2013 and 7/3/2013. I really need some help.

Thank you in advance,



NovicetoAccess

[orange]

This has been answered ( perhaps more than once)

see https://www.accessforums.net/access/...ons-53650.html

and don't overlook Google to help you find things