automatic query by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is going to be a simple solution but I can't figure it out.... I
want this query to automatically run this equation and not have to enter the
date each time.

I want to query a table that displays all records 3 months prior to the
current date..

example for 03/09/06 I want the query to show all records inputed since
12/09/05.

Thanks in advance...Jen
 
Jen said:
I know this is going to be a simple solution but I can't figure it out....
I
want this query to automatically run this equation and not have to enter
the
date each time.

I want to query a table that displays all records 3 months prior to the
current date..

example for 03/09/06 I want the query to show all records inputed since
12/09/05.
Click to expand...
Hi Jen,

I believe you want

WHERE
[somedatefield] > = DateAdd("m", -3, Date())

good luck,

gary
 
Hello Jen.
I know this is going to be a simple solution but I can't figure it out
.... I want this query to automatically run this equation and not have
to enter the date each time.

I want to query a table that displays all records 3 months prior to
the current date.
Click to expand...

In the criteria box, type the following:
 
Back
Top