Automatically create default alias for SUM(), COUNT() etc. columns in GROUP BY query

Avatar
  • updated
  • Completed
In a GROUP BY query with columns like "SUM(sales)" etc. it would be great if a default alias (i.e. "SumOfSales") could automatically be created for those columns.  The user can then change them if necessary.

That is what the MS Access visual query builder does and it saves a lot of time manually typing in the aliases where, most of the time, something like "SumOfSales" or "CountOfOrders" would be perfect.

Thanks!

Pete