Crosstab - ORDER BY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to get around the fact that you can't ORDER BY an aggregate
function?

thanks,
c
 
Yes, use the aggregate query as the input to a select query

Select * from qryMyAggregate order by CountOfField1
 
Back
Top