IIf statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a labor invoice form and am trying to write an IIf statement
that deals with the following information:
r time, o time, p time
The employee will work either regular time, over time or premn time. (Never
multiple times in a work day) I need the IIf statement to fill in the cell
based on type of time the employee submits.

I am using the following IIf Statement :
=IIf(IsNull([r time] Or [o time]),[p time])
 
Hi

Time: IIf([SubmitField=[r time],[r time],IIf([SumbmitField]=[o time],[o
time],[p time]))


I have assumed that you will select the “type†of time from a field called
SubmitField you can change this to whatever it is you use.

Just a point – I would change your field names to get rid of the spaces.
[r time] to [r_time]
[o time] to [o_time]
[p time] to [p_time]

Good luck with your project
 
Sorry - [SubmitField should be [SubmitField] (typeing error)

Time: IIf([SubmitField]=[r time],[r time],IIf([SumbmitField]=[o time],[o
time],[p time]))
 
Not sure if that what you are looking for, select by priority
1. [r time]
2. [o time]
3. [p time]

IIf(Not IsNull([r time]),[r time], IIf(Not IsNull([o time]), [o time] , [p
time]))
 
Back
Top