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