Using an expression in a query prevents the Microsoft Jet query optimizer from using the field for index or Rushmore optimization. In addition, expressions are evaluated for every record, not just the records that are returned. You can significantly improve performance by removing embedded expressions from queries. The best place to put expressions is in forms or reports because then expressions are only evaluated for the records returned.