Summary functions cannot appear in a WHERE clause, so using a subquery is often a good technique. Employees who earn less than the department's average salary are returned in Output from a ...

Use saved queries as opposed to SQL statements as the data sources for Access objects. The wizard will create a corresponding SQL Server object for each saved query.

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.