Query Date criteria

I have a query that has a date criteria that is in a range. For example it
runs from 1/01/08 to 03/31/08.

Is it possible to change the criteria so it always run the past 3 months
from the date is was run. So for example, if I ran it today (07/18/08) the
criteria field would select the last 3 months from today, so 04/18/08 to
07/18/08.

Can you do that in the query?


OR
is it possilbe to have it prompt the user for which quarter of the year to
run?


Thanks,
Jasper

On Jul 18, 7:49*am, "Jasper Recto" wrote:
I have a query that has a date criteria that is in a range. *For example it
runs from 1/01/08 to *03/31/08.

Is it possible to change the criteria so it always run the past 3 months
from the date is was run. *So for example, if I ran it today (07/18/08) the
criteria field would select the last 3 months from today, so 04/18/08 to
07/18/08.

Can you do that in the query?

OR
is it possilbe to have it prompt the user for which quarter of the year to
run?

Thanks,
Jasper

SELECT Contacts.EMailAddress, Contacts.InterviewDate
FROM Contacts
WHERE (((Contacts.InterviewDate) Between DateAdd("m",-3,Date()) And
Date()));