- NEW!
by Cyanotic Wasp on March 6th, 2009
You can make it an interactive query if you include a Criteria line under HireDate such as:
> [Cutoff hire date?]
When the query is run, you'll get a window for "Enter Parameter" which will ask (depending on the text you used above -- it mirrors slavishly what you use as a prompt):
Cutoff hire date?
And now you can enter any date you want to use rather than have to re-edit the query whenever you want to change that parameter. This will make your queries a lot more powerful and usable.
In MS Access, how do I tell a field to return a date value that is always, say, seven days before a date value entered in another field?
by elliottline on November 26th, 2010
| 1 person likes this
How can I create a Database that update data automatically every month or every year using Access or any other application by query?
by jojojojo2 on August 17th, 2010
| 1 person likes this
How do I store user-inputed data in unbound textbox on a form to variable so that I can call it to another unbound textbox on another form?
by jtlinx on October 25th, 2010
| 1 person likes this
I need help please to calculate weeksdays in a month (Monday, Tuesday, etc)in a querry without using vba.
by Silver_A on April 13th, 2010
| 1 person likes this
Combobox on switchboard in Access w/dropdown list of employees. Names are selected prior to entering data. I want to request their password.
by aahaynes on January 11th, 2011
| 1 person likes this
You're reading I am making a query and i need to specify all the people hired after a certain date how would i do that?
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Comments