IF expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to populate a field [Available] with the result of a comparison. If a
date [lease end] is before the current date, I need the value in the
calculated field [Available] to be YES, otherwise NO. I can do this is Excel
but not in access. Can anyone help?
 
I assume you aren't attempting to store the value, only display it in a
query. Use a column like:

Available: IIf([Lease End]<Date(),"YES","NO")
 
Back
Top