An excellent idea! Thanks for your help. It saved the day.


>Tim -- you may be able to use a derived table in the FROM clause to get around this. If you could post a bit of the code I will try reworking it to show you what I mean.
>
>>I am trying to specify a select statement as a column in SQL 7.0. The query contains a Group By clause and I am getting an error telling me I cannot perform an aggregate on expression that contains a subquery. Is there a way around this?