Hi group,
Below is my sql so far. I want to be able for this sql search 2 days before and 1 day after. For instance, if I enter 5 5 5 and that number came on 10/31/2006. I want to see the numbers that came on 11/1/2006 and 11/2/ 2006 and 10/30/2006.
SELECT YourTable.YourNumber, YourTable.YourTable, YourTable.YourDate, MoonPhaseTable.MoonPhaseTable, MoonPhaseTable.YourNumber
FROM YourTable INNER JOIN MoonPhaseTable ON YourTable.YourDate = MoonPhaseTable.YourDate
WHERE (((YourTable.YourNumber)=[Enter Number]));
Please help me and thank you