Query Question

[Dungmitten]

I'm a noob with Access and was wondering why this isn't returning what I want - I want to type in the amount of days when runnung the query but it returns spurious data?


SELECT main.SingleID AS LEID, main.Connection, Facilities.[DI Type], Facilities.[Expiry Date], Facilities.[Limit £000s], DateDiff("d",Now(),[Expiry date]) AS [Days Before Limit Expiry]

FROM main INNER JOIN Facilities ON main.SingleID = Facilities.LEID

WHERE (((DateDiff("d",Now(),[Expiry date]))<[Enter Days] And (DateDiff("d",Now(),[Expiry date]))>1))

ORDER BY Facilities.[Expiry Date];

 

[boblarson]

Don't use NOW as it includes time. Use Date() where you used Now()