can if statement be included in the Calculation field in query?
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]
