Hello,
I am working on a query. I have database the consist of the Moon phases and the day of the week of the phases of the moon and the date of the moon.
For instance, 10/02/2020 Fri 1 (1 means it was a full moon)
In my design view I have a criteria that says Enter moon phases I enter 0.97 then it runs and I am able to see all the phases of the moon with 0.97 phases and the day of the week it fell on and the date.
How do I show in access design view the previous date and the next day phases. I want to see the phases of the moon one day before 0.97 and one day after 0.97.
Please assist me