Greater than date to multiple criteria

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
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.
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top