Access SQL Alias

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

Guest

Dear All,

using a sql query on an access database, how do you use aliases on access
because the following that works with SQL doesn't with access, trying to give
count(*) the alias of number:

select town, number=count(*)
from
contact
group by town
order by town asc

Regards

Matt
 
sorry posted in wrong place - and I must have been having a blond moment - as
I remembered how simple it was to do .. sorry
 
Back
Top