|
Administrator: Receipts
The IIF() function is a logical
statement, similar to the one used in
Microsoft Excel. Here is the question in plain words:
If you subtract the video
rental:
(Left([Description],1)
from the days rented
DateDiff("d",[DateRented],Now())
and that amount is greater than the days rented,
then it's, “Overdue.”
If not, then it's, “Not Overdue.”
Save your query and test
the results.
Home ->View ->Query Design
|
|||
|
| |||
