I am making a query and i need to specify all the people hired after a certain date how would i do that?

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'

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.

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

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.

Search a string in a date column, (greater than)