Question: I need to make a query for the Step 2 argumant. I know I need to use datepart function for it but I'm not sure
Step 2. Create a query that prompts the user to enter two different years and displays the first names, last names, and titles of employees that were born between those two years. Sort the result in ascending order by employees' first names. Save this query as Query1. Run this query and enter 1950 and 1960 , the result should look like: (The result is complete) tep 2. Create a query that prompts the user to enter two different years and displays the first names, last names, and titles of employees that were born between those two years. Sort the result in ascending order by employees' first names. Save this query as Query1. Run this query and enter 1950 and 1960 , the result should look like: (The result is complete)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
