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.

It is possible to automate Access from Excel using VBA code, this woukld allow you to run any queries, also those containing user defiend functions. So you could run a query to empty the tabel and ...

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.