The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve data. This query returns the names of employees who earn less than the average ...

buiild a query that has Month Count (*) fields. then update. if Access says none updatable qruery then do a make table with the sql then update.<BR><BR>Or you could program the solution.

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!