I am making a query and i need to specify all the people hired after a certain date how would i do that?
by 
Anonymous
ANSWERS: 6
-
I'm assuming you know how to make a query. Make a new query in design view and add the table. Click the View menu->SQL view. Type "Select * from [tablename] where [date of hire date field] > #1/1/2000#" (without the quotes.)
-
I will assume you know how to create a query, to start with. Make sure you include the field that specifies a start date, and also be sure that all dates are consistent in format. You may actually want to go back to the table that contains these dates and assign a "date" format to the field. In the query, choose the Start Date field from your table. in the Criteria, under that field in your query, simply put a greater-than sign, and then the certain date that you are using. For example: If I want to only show people hired after 9/2/2007, I would put ">9/2/2007" in the criteria.
-
With the query in Design View put the following in the Criteria row of the grid in the employment date field (column): Between [Beginning Date] And [Ending Date] When you run the query you will be asked to type in the start and end dates of the period you want to see.
-
you can approach in the following manner: select 'all people' from 'tablename' where joining date > 'certain date'
-
Search a string in a date column, (greater than)
-
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.
Anonymous RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC