Search results

Sum in footer Hi, I'm placing a unbound text control in the form footer that sums a calculated field on the page. I keep getting an Error. It's a subform so I want to get the sum of all records for that employee. I tried =Sum([Options Vested] and I got an error. Also tried =Nz(Sum([Options...

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...

Thanks Thanks so much

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...

Thank You Thanks so much. Your example helped and I was able to make it work.

One more question I've created 2 fields and just want to make sure I'm on the right track. The first field has the primary key, employee number saved. The second field has the query but I'm having a problem with it. So in my 2nd field which is Name, in the Control Source of the field...

Not sure I'm using the same field on one form to enter and save the data. So the user would use the lookup to enter or change a name in a field. Should I be using 2 fields? 1 to store the primary key and 1 to display the data? I'm not quite sure since I'm new at this. Thanks

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...