Using SQL Server 2005 from an ADP front-end. I am trying to recreate an Access query in the ADP. I'm having trouble creating a field based on an expression such as NewField:if(x,y,z). Is this possible? Also, can I use a form field reference as a criteria expression in the new query?