If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Making Excel generate Access-Like Reports | VJ7777 | General Discussion | 15 | September 12th, 2004 05:48 AM |
Query Criteria where a single date comes from a form | Gary O | Running & Setting Up Queries | 3 | July 23rd, 2004 05:24 PM |
Date Criteria on Query | xx | General Discussion | 1 | July 16th, 2004 01:26 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
lookup a sum of multiple values for a single date | Mic | Worksheet Functions | 2 | October 22nd, 2003 05:52 PM |