J John Vinson Feb 25, 2005 #3 can if statement be included in the Calculation field in query? Click to expand... Yes; use the IIF function. Open the VBA editor (by typing Ctrl-G for instance) to bring up the correct help file, and search for help on IIF. In essence, you'ld use CalculatedField: IIF(LogicalExpression, ValueIfTrue, ValueIfFalse) John W. Vinson[MVP]
can if statement be included in the Calculation field in query? Click to expand... Yes; use the IIF function. Open the VBA editor (by typing Ctrl-G for instance) to bring up the correct help file, and search for help on IIF. In essence, you'ld use CalculatedField: IIF(LogicalExpression, ValueIfTrue, ValueIfFalse) John W. Vinson[MVP]
