Need help with a step with an Access Assignment!!!

[Cpresley]

I have been asked to: 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.

[ItsMe]

Add criteria of Overdue to the column you just created, so only the employees who are Overdue display.

I would worry about this part last.

I guess the assignment is to use the Query Designer/Builder to create a query object. Do you know how to create an alias? It seems you will need to add a new column using an alias.

[Cpresley]

Yes I am to use the query builder but do not know how to create an alias? This is the first time I have ever opened access

[Cpresley]

Yes I am to use the builder...I think with an IIF(IsNull..... function? I am not familiar with alias?

[ItsMe]

I would use an IIf. To create an alias, you need to place the name of your alias in a new field/column. Directly after the name, place a colon. MyAliasName:

After the alias name and the colon, you can place your expression (IIf)
MyAliasName: IIf(FieldName > 1000, "Large", "Small")

https://msdn.microsoft.com/en-us/lib...ffice.14).aspx