Greater than date to multiple criteria

In Access how can I reference a " date" (greater than date), i.e.,
9/9/2004, from one cell to many Queries (20) as Criteria. I can do it with
a single date, i.e., 9/9/2004, but have not been able to reference with a
"greater than" date. The Queries work when I manually change each " date",
but I want to eliminate the time necessary to change 20 greater than dates
every week. Thank you in advance for your assistance.

Create a frmParameter with a TextBox so that the user can enter the
parameter value and a CommandButton to run the Queries.

In each of the Queries, use the full reference to the TextBox as the
Parameter.

When the Query is run, Access will use the value in the TextBox as the value
of the Parameter. Of course, the frmParameter needs to be open (hidden if
required) when the Queries are exceuted.

--
HTH
Van T. Dinh
MVP (Access)



"Bill Malmgren" wrote in message
...
In Access how can I reference a " date" (greater than date), i.e.,
9/9/2004, from one cell to many Queries (20) as Criteria. I can do it
with
a single date, i.e., 9/9/2004, but have not been able to reference with a
"greater than" date. The Queries work when I manually change each "
date",
but I want to eliminate the time necessary to change 20 greater than dates
every week. Thank you in advance for your assistance.