by Anonymous on September 2nd, 2008

Anonymous

Question

Help answer this question below.

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

  • Like
  • Report

Answers. 6 helpful answers below.

  • by Brian I on September 2nd, 2008

    Brian I

    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.

    • Like
    • Report

    1 comment | Post one | Permalink

  • by Pranav on March 6th, 2009

    Pranav

    you can approach in the following manner:
    select 'all people' from 'tablename' where joining date > 'certain date'

    • Like
    • Report

    No comments. Post one | Permalink

  • by Penal Colony is wicked marrying Andy on September 2nd, 2008

    Penal Colony is wicked marrying Andy

    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.

    • Like
    • Report

    No comments. Post one | Permalink

  • by krazymike on September 2nd, 2008

    krazymike

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

    • Like
    • Report

    No comments. Post one | Permalink

  • by Cyanotic Wasp on March 6th, 2009

    Cyanotic Wasp

    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.

    No comments. Post one | Permalink

  • by laser on March 6th, 2009

    laser

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

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

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?

Follow us on Facebook!

Related Ads

ANSWERBAG BUZZ

Need an answer of 0 in access query
Microsoft access hired after
Specify table and field in access query
Specify date in a query on access
Make a query to ask for a certain date from access database