I am doing an exercise. I did not get the first problem of the exercise correct and don't understand why.
On the second problem, I was deducted 3 points and don't understand what am I doing wrong.
Could you please take and look and tell me what I am doing wrong?
I will attach the database.
These are the problems:
Open the Find Low Quantities query in Design view. Add criteria for the OnHandQty field. The user should be prompted to Enter Threshold. The query should display all results that are less than or equal to the threshold but greater than or equal to 1. Run the query. Enter 2 when prompted to Enter Threshold. You should have one result. Save and close the query.
Open the Overdue Reviews query in Design view. Add a new column to determine if an employee’s performance review is overdue. If the employee’s DateOfLastReview is null, it should display Overdue. If not, it should display nothing. Name the column ReviewStatus. Add criteria of Overdue to the column you just created, so only the employees who are Overdue display. Run the query. Ensure only employees with null DateOfLastReview display. Save and close the query.