I need to Query RepID if Form REPID is open - if it is not Open I need to Query EMPID
REPID and EMPID are numbers
In Query Builder
Under REPID iif([forms]![Form1]![TxtRepID]>0,[forms]![Form1]![TxtRepID],"")
Under EMPID iif([forms]![Form1]![TxtRepID] ??,[forms]![Form1]![TxtRepID],"")
so if there is a value in [forms]![Form1]![TxtRepID] Query for the REPID
if there is no TxtREPID (because the form is not open Query for EMPID