Greater than date to multiple criteria

  • Thread starter Thread starter Bill Malmgren
  • Start date Start date
B

Bill Malmgren

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
Click to expand...
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.
 
Back
Top