Filter date field for last three weeks

[Mansoor Ahmad]

Dear All

I have a customer based database. Customers are visited at regular intervals and visit dates are recorded.

On a form user selects a customer from a combo box and it filters the data and shows records for that customer. I want to show the history of that customer in a subform over last three visits only.

In a query I want to set a criteria on a Visit Date field which would search for records 3 weeks old.

Can somebody please tell me how can I do it?

Thanks

 

[FoFa]

[MyDate] >= DATEDIFF("dd",-21,now())

Like that?