I have this code below that when I enter the 3 digit number when the pop up box comes up. Now I know want to change the code below to enter the moon percentage from the moon percentage table
when the pop up box comes up. Please help me I want to change the code below so that the pop up box will ask me to input the MoonPhase Number first. Thank you
SELECT T1.YourNumber AS [Operative Number], T1.YourDate AS [Operative Date], T2.YourNumber AS [Related Number], T2.YourDate AS [Related Date], M1.YourNumber AS [Moon Phase Number]
FROM YourTable AS T1, YourTable AS T2, MoonPhaseTable AS M1
WHERE T1.YourNumber = [Enter Number:]
AND T2.YourDate >= T1.YourDate-2
AND T2.YourDate <= T1.YourDate+2
AND T2.YourDate <> T1.YourDate
AND M1.YourDate = T2.YourDate
ORDER BY T1.YourDate, T2.YourDate;