Recent content by Ketonekevin

  1. K

    Using if statement to fill a field depending on other records in the table...

    Actually, it is a fun place to work... What this is for is supervisors logging their contacts with their workers as part of the safety program here. At the end of the month, we collect the data from the supervisors. From that pile of data I am trying to calculate a percent compliance for...
  2. K

    Using if statement to fill a field depending on other records in the table...

    Hello all, I have a simple table as follows: Field 1 - Name - text field Field 2 - Date - Date/time field Field 3 - Hours Worked - Number field Now what I would like to do with a query is this. Look at each record, if there is no record for the same name for yesterday, then place the...
Back
Top Bottom