On Time/Late Response

  • Thread starter Thread starter Boeing55
  • Start date Start date
B

Boeing55

I have two seperate fields with the same type information "2/11/2008 4:49:23
PM", date created and date of response.
I'm trying to write an expression that will compair the two fields that will
tell me if the response was on time or late.
 
How would you determine if a response was "on time"?

If you were to hand a temp a stack of data (DateCreated, DateOfResponse) and
ask him/her to determine "on time" or "late", how would you instruct him/her
to do that?

Access is less intelligent than a temp! You will have to be very explicit!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Date Created and Date Of Response seem to be two fields. How do these
two fields tell you whether or not something was on time or it was late?

For instance, if Date Created occurs before Date Of Response does that
mean that the Date of Response was Late or On time or does that not have
any relevance in determining the lateness of the response.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top