Search results

Hi, the following is a small part of a much larger query in Access. I'm trying to convert the query to an SQL view, but the syntax has me stumped!:confused: There are 2 problems. 1) [Completed]=False AS OJ (should return 0 if false or 1 if true) 2) IIf([BRef]='B001',0,1) AS BR (should return 0...