Is there any way to get around the fact that you can't ORDER BY an aggregate function? thanks, c
C c Jan 26, 2005 #1 Is there any way to get around the fact that you can't ORDER BY an aggregate function? thanks, c
J JohnFol Jan 26, 2005 #2 Yes, use the aggregate query as the input to a select query Select * from qryMyAggregate order by CountOfField1
Yes, use the aggregate query as the input to a select query Select * from qryMyAggregate order by CountOfField1
