iif statement using time

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I would like to create an iif statement to peform this:

I have a form that has a button employees click to login. When they click
this button, the time appears in a textbox ([Login]). I would like for
another textbox ([Report]) to show whether or not the employee was late. The
new textbox ([Report]) should say the words "Late" or "OK" depending on
whether or not they logged in before 8:05 AM.

Thanks.
 
If it is JUST the time in the LOGIN then you should be able to use

=IIF([Login]<=#08:05:00 AM#,"OK","Late")

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top