Search results

  1. M

    Sum of a field

    Hi, I have a field on a form that I'm calculating called Options Vested. I'm creating another field on the form called Total Options Vested where I want to total all the Options Vested for that Employee. The two fields don't exist in the table since I'm doing calculations. I tried this but I...
  2. M

    IIF statement

    Hi, I'm trying to calculate the value of a field based on the other columns in the table. It's working in a form but I need to save the value in the table. I'm selecting the default value of the field and entering the following: IIf(DateDiff('m',[Vesting Start Date],Date())>12,0.25*[Number of...
  3. M

    Value from ComboBox

    I can't seem to save the correct value from a lookup table into a field. I have 4 fields: SS#, Last Name, First Name, Middle Initial I would like to save the Last Name, First Name into the field. I can just save the Last Name. Is there a way to combine the values or to save more then one bound...
Back
Top Bottom