I have a column in my table that contains the Beginning Equipment Usage (begeqp). In my Edit form I want to set the begeqp to the high usage value (eqphigh) of the eqphigh table, otherwise I want to use the current value of begeqp. I tried using IFNULL as shown below:
(ifnull(begeqp,eqphigh in eqphigh where dotnum eq dotno,begeqp)) And got the following error. The first and last arguments for IFNULL must be the same type. )2155) They are not only the same type, they are the same variable. How can I do this? Thanks, Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 [email protected]<mailto:[email protected]> Please note: e-mail may be subject to public disclosure.
