Date querie

[Fred]

I need to know how to build a querie that can search 3
days before and 3 days after todays date. It will be used
in a date column. Is there a way to do this? Thanks for
any help.

 

[Van T. Dinh]

SELECT *
FROM YourTable
WHERE DateField
Between DateAdd("d", -3, Date())
And DateAdd("d", 3, Date())