I have a database and I want two parameters. I have one already I want to know when I a create this query how can I put a date that show 2 days before and 2 day after the date I entered along with the date I entered.
For instance, If I put in 5/1/2016 I want my database to show the numbers that came on that date and 2 days before and 2 days after that date I entered
so far this is my sql statement
SELECT [All Table Summary].MoonPhaseYourNumber, [All Table Summary].YourDate, [All Table Summary].Cash4YourNumber, [All Table Summary].GAFiveYourNumber, [All Table Summary].YourTableYourNumber
FROM [All Table Summary]
WHERE ((([All Table Summary].MoonPhaseYourNumber)=[Enter Moon PhaseNumber]));