In ASP I would like to run a SQL query inserting a an additional work field. Then code that work field in the output using a record by record formula based on the contents of several fields.<BR>Then take the resulting coded output table or recordset and input that into another SQL query to summarize the records based on this code. <BR><BR>Is this possible?